How to index the data of last column

[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

 

[Mallycat]

Man, that is confusing. What are you trying to do?

 

[Ardus Petus]

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

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


HTH

 

[Ardus Petus]

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