|
|
|
|
#1
09-15-2015, 02:51 PM
|
|||
|
|||
I think I coppied the wrong cell. That was the formula I had in row 16 and for some reason FALSE has a space in it. I guess you figured that out. =IFNA(IF(ISBLANK(A12),"",INDEX(A13:A110,MATCH(FALS E,ISBLANK(A13:A110),0))),"") I also took out the $ since that would only allow for 100 rows max. 
|
|
#2
09-15-2015, 04:13 PM
|
|||
|
|||
|
Yep, I fixed the space in "FALSE", and adjusted the range for my actual. I was going nuts trying to get the match syntax correct inside my version of the array. Your solution was spot on -- much appreciated!
|
|
|
|
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 |
Windows 10 
Office 2013
Hybrid Mode