You're welcome, Bob - 1E100 is a bit easier to type than
9.99999999999999E+307 (Excel's largest number), and is usually large
enough in most situations.

Pete

On Jul 14, 1:17 am, "Bob" wrote:
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- Hide quoted text -

- Show quoted text -