Finding value in the last cell in column A

  • Thread starter Thread starter Snoopy
  • Start date Start date
S

Snoopy

Hi
I have this expanding Excel-database, and on all occasions I want to
use the latest (max rowindex) value of the datainput in column A.
I'm certain this is a-piece-of-cake, but what kind of formula is to be
used?

Kindly regards
Snoopy
 
Try either:
=LOOKUP(99^99,A:A) will show the last number in column A

=LOOKUP(2,1/(A1:A65535<>""),A1:A65535) will show numbers or text.

Hope this helps
 
Back
Top