Finding the LAST value in a column
 

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

Finding the LAST value in a column
 

=LOOKUP(10^99,A:A)

will return last value in column A

HTH

"John O'Boyle" wrote:

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

Finding the LAST value in a column
 

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

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

will return last value in column A

HTH

"John O'Boyle" wrote:

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

Finding the LAST value in a column
 

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

John O'Boyle wrote:
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

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

will return last value in column A

HTH

"John O'Boyle" wrote:

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

Finding the LAST value in a column
 

Toppers wrote...
=LOOKUP(10^99,A:A)

will return last value in column A
....

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))

Finding the LAST value in a column
 

Harlan Grove wrote...
....
=IF(COUNT(A65536),A65536,LOOKUP(2,1/NOT(ISBLANK(A1:A65535)),A1:A65535))

Make that

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

Finding the LAST value in a column
 

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

"Harlan Grove" wrote:

Harlan Grove wrote...
....
=IF(COUNT(A65536),A65536,LOOKUP(2,1/NOT(ISBLANK(A1:A65535)),A1:A65535))

Make that

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