How to index the data of last column

M

Macneed

How to index the data of last column
if the column contains blank data
ex.
1 2 _ 3 4 _ 8 5
if didn't use temp data
is it possible to get the "5" by one formula?

Thanks a lot
 
A

Ardus Petus

=INDEX(1:1,1,MAX((COLUMN(1:1))*(NOT(ISBLANK(1:1)))))

Array formula, to be validated with Ctrl+Shift+Enter


HTH
 
A

Ardus Petus

No need for so many parenthesis:
=INDEX(1:1,1,MAX(COLUMN(1:1)*NOT(ISBLANK(1:1))))
 
Top