View Single Post
 
Old 09-15-2015, 02:12 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

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