I think LARGEST is the good term instead of greatest!
Stefi


€žStefi€� ezt Ã*rta:

This is nicer and more secure than my solution, and it cleared an error in XL
Help, at least in the Hungarian version (so it can be a translation error).
Hugarian Help states that if LOOKUP doesn't find the value it returns the
greatest (legnagyobb) value in the lookup array. Your formula cleared that it
returns the LAST (utolsó) of the array!

Thanks,
Stefi


€žRagdyer€� ezt Ã*rta:

Try this:

=LOOKUP(99^99,A:A)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Steve" wrote in message
...
Column A contains a list of numbers. This list will vary in length. Cell
C1
needs a formula to display the last (but not necessary largest/smallest)
figure in this list.

Any help would be appreciated