Finding value in the last cell in column A

Finding value in the last cell in column A

Post by Snoop » Fri, 03 Apr 2009 15:52:32


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
 
 
 

Finding value in the last cell in column A

Post by Um9uQEJ1e » Fri, 03 Apr 2009 16:48:01

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