![]() |
#4
|
|||
|
|||
![]()
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. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
ubns | Excel Programming | 2 | 04-12-2015 06:31 AM |
![]() |
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 |
![]() |
Learner7 | Excel | 1 | 04-19-2011 02:45 AM |
![]() |
FraserKitchell | Excel | 4 | 02-26-2010 10:38 AM |