Formula Question

[GMckown]

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.

1

2

3

4

3

Thank you in advance!

[#2]

@GMckown 

It could be

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

[#3]

@GMckown 

Or even

=LOOKUP(1E+38,array)

[#4]

@Hans Vogelaar 

Oh, sure, sorry