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