![]() |
|
#2
|
|||
|
|||
|
=IFNA(IF(ISBLANK(A16),"",INDEX(A17:$A$100,MATCH(FA LSE,ISBLANK(A17:$A$100),0))),"")
make sure to do a CTRL+SHIFT+ENTER when you first paste it in. This will find the next non empty cell in "A" and put it in "B" otherwise it will return nothing and when it gets to end it will leave nothing since there is not another I am assuming that you won't have any more than 100 empty rows between numbers. If that is the case you can just increase that number or use something like =macth(9.99999999999999E+307,A:A,1) to get the last cell in your row. |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
If id cell range is empty then should not allow to fill any other cell
|
ubns | Excel Programming | 2 | 04-12-2015 06:31 AM |
Excel Formula: return a range of cells that match
|
tinfanide | Excel | 4 | 08-30-2014 07:03 AM |
| Change formula cell range based on cell value | Scoth | Excel | 4 | 10-25-2012 07:51 AM |
How to remove blank rows from a specified range?
|
Learner7 | Excel | 1 | 04-19-2011 02:45 AM |
Moving formula range multiple cells when moving sum over one cell
|
FraserKitchell | Excel | 4 | 02-26-2010 10:38 AM |