software

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 Studentquot;Charles Drummerquot; wrote:

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


This will also work:

=OFFSET(A1,COUNT(A:A)-1,0)--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: www.excelforum.com/member.php...oamp;userid=32763
View this thread: www.excelforum.com/showthread...hreadid=526110