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