Last Numeric value
=LOOKUP(9.99999999999999E+307,A:A)
Last Text value

--
Gary's Student


"Charles Drummer" wrote:

I guess this should be very simple but ...

If I have a column with let's say 6 records (unsorted amounts) and every day
I am adding a new record to the next cell until (e.g.) 20 values then I want
that one cell shows the most recent value that has been input in the row, so
that one which has the lowest position in this column - is there a formula
that can do it?

Thanks in advance