View Single Post
 
Old 09-15-2015, 02:51 PM
trainingclc trainingclc is offline Windows 10 Office 2013
Novice
 
Join Date: Sep 2015
Location: Houston, TX
Posts: 16
trainingclc is on a distinguished road
Default

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.
Reply With Quote