Forum Discussion
Formula ?
In a row array of cells, I need a formula the selects the last data cell with data in the array? 1 2 3 4 3 Thank you in advance! Thank you in advance!
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)