Formula Question

New Contributor

In a row array of cells, I need a formula that selects the last data cell with data in the array? In this example would return a result of 3.

 

12343   

 

Thank you in advance!

3 Replies

@GMckown 

It could be

=LOOKUP(1E+38,array,array)

@GMckown 

Or even

 

=LOOKUP(1E+38,array)

@Hans Vogelaar 

Oh, sure, sorry