Finding the LAST value in a column

J

John O'Boyle

I'm not new to Excel, but so far I've only managed to deal with add,
subtract, multiply, and divide - in other words, nothing fancy. I now
find myself needing to learn a little more. I have a column which
contains a series of numbers. I add a new entry to this column each
week or so. I would like to always be able to to obtain the "last"
number in this column regardless of the column's length. I thought that
perhaps I might want to look for the first blank cell in the column and
back up one row to get the data, but perhaps that isn't the easiest way
to do it. Any suggestions or help any of you might offer would be
gratefully appreciated.

Thank you.
John O'Boyle
 
J

John O'Boyle

Thanks Toppers. I appreciate it. I do have a problem however. I'm not
sure how to enter the 10 to the 99th power expression. I entered it as
it appears below, and it didn't work. Sorry to appears so dim, but some
of this is new to me.

Thank you.

John O'Boyle
 
J

John O'Boyle

Check that! It was the nut at the keyboard. I copied the formula and
forgot to change the column indicators. All is well. Thank you very much.

John O'Boyle
 
H

Harlan Grove

Toppers said:
=LOOKUP(10^99,A:A)

will return last value in column A
Click to expand...
....

Picky: it'll return the last numeric value in the column, but it won't
return any, text, boolean or error value that might come after the
last numeric value. To return the last value regardless of type,

=IF(COUNT(A65536),A65536,LOOKUP(2,1/NOT(ISBLANK(A1:A65535)),A1:A65535))
 
H

Harlan Grove

Harlan Grove said:
=IF(COUNT(A65536),A65536,LOOKUP(2,1/NOT(ISBLANK(A1:A65535)),A1:A65535))
Click to expand...

Make that

=IF(COUNTA(A65536),A65536,LOOKUP(2,1/
NOT(ISBLANK(A1:A65535)),A1:A65535))
 
T

Toppers

The OP did say numbers... so I don't feel too guilty! But appreciate your
response.
 
Top