Formula ?

Copper Contributor

In a row array of cells, I need a formula the selects the last data cell with data in the array?

 

12343   

 

Thank you in advance!

 

Thank you in advance!

1 Reply

@GMckown 

Let's say these data are in row 2.

If all values are numbers, the last one is returned by the formula

 

=LOOKUP(9.99999999999999E+307,2:2)

 

(9.99999999999999E+307 is the largest value one can enter in a cell, so all values in the row will be smaller)