How can I reference the last data item in a column or row?

S

snappy

I want to display or use the last (most recent) data in either a column

or row withour specifically accessing the individual cell. Is there a
funcion similar to Min() or Max() that can help me or perhaps another
way to solve this question?


Thanks
 
B

Biff

Hi!

Try this:

Note: this will not work on an entire column, i.e. A:A, but will work on an
entire row, i.e. 1:1

=LOOKUP(2,1/(A1:A20<>""),A1:A20)

Biff
 
Top