Finding value in the last cell in column A

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
 
R

Ron@Buy

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatic expanding formula bar in Excel 2007? 1
Building folder-list in Excel 3
Sending a copy of spreadsheet to mailrecipient; mail adress indicatedin a cell in the spreadsheet 4
Inserting filename in Excel worksheet 1
Macro: set filter containing certain value(s) 2
Sending copy worksheet to mailrecipient - mail adress indicated incell in worksheet 1
Make a complete list of words from texts in a range 3
Last Value in a Column when Value <> 0 1

Top