=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