Thank you.

Bob

"Pete_UK" wrote in message
ups.com...
Assuming your figures (numbers ?) are in column A, try this in B1:

=LOOKUP(1E100,A:A)

Hope this helps.

Pete

On Jul 14, 12:40 am, "Bob" wrote:
Excel 2003

I think this is easy but I don't know how to do it. I have a column of
figures that we keep adding to and it gets longer and longer. I just
need a
formula that will return the last figure in the column at any given
time.

Thanks in advance... Bob