Janice
Reputation: 11
Can excel set ranges from blank to blank in a column
I have a column of numbers in excel that are separated by blanks. Each group of numbers (between blanks) varies in quantity so the first group may have 5 numbers, the next 2 numbers, the next 6. I need to have excel select each group so I can run a formula to extract the largest number and the smallest number from each group. I know about min/max but don't know how to get excel to go from blank to blank setting ranges.
Upvotes: 1
Views: 31
Answers (1)
Scott Craner
Reputation: 152465
You can use a similar formula to this:
=IF(OR(A1="",ROW(A1)=1),MAX(A2:INDEX($A2:$A$18,MATCH(TRUE,INDEX($A2:$A$18="",0),0))),"")
So with the data in column A and the max in Column B:
Upvotes: 1
Related Questions
- Sum numbers in between blank cells in Excel
- Paste into blank cells in excel?
- Ignore blank cells in my Excel INDEX formula
- Excel formula to calculate the sum of the first n% visible rows in a filtered column
- Index Match - Removing Blanks From Table Column
- Is there an excel formula to extract numbers from the last 25 rows in a column with mixed data?
- In Excel list the Top 10 account balances from one column based on the data in another column
- How do I find the last non-blank non-zero positive value in a column/range?