How do I find the last number in a column of numbers?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Excel, if I have a column of numbers, how do I tell Excell to find the
last number in that column?

Thanks

Shyam
 
Hi!

Try this:

Numbers in column A

=LOOKUP(9.99999999999999E+307,A:A)

Biff
 
Hi Biff,

Very clever - worked beautifully - thanks for the assistance.

Shyam
 
You must log in or register to reply here.

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

Help needed 0
Red cell for negative numbers in Excel 1
Convert Number to Text for Index/Match 1
Sum the last 5 numbers in a column 6
SUMIF with criteria "<>" & "=" 4
Excel Convert word into numbers and back 4
row number of last non-blank cell 14
Finding Last number in a column 3

Back
Top