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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I find the last number in a column of numbers? (https://www.excelbanter.com/excel-worksheet-functions/42441-how-do-i-find-last-number-column-numbers.html)

Shyam

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

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

Thanks

Shyam

Biff

Hi!

Try this:

Numbers in column A

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

Biff

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

Thanks

Shyam

Shyam

Hi Biff,

Very clever - worked beautifully - thanks for the assistance.

Shyam

"Biff" wrote:

Hi!

Try this:

Numbers in column A

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

Biff

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

Thanks

Shyam

All times are GMT +1. The time now is 05:58 AM.