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

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

This will also work:

=OFFSET(A1,COUNT(A:A)-1,0)


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=526110