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)
