undating new value while keeping the old

[YJL]

I have a worksheet that keeps undating everyday. I want to track the
latest row's value and still keep the old one.

Example

A1 will always point to newly updated cell (B1, B2, B3 ... )

Day1, update on B1 <--A1 shows value of B1
Day2, update on B2 <--A1 shows value of B2
Day3, update on B3 <--A1 shows value of B3

 

[Max]

One way,

Put in the formula bar for A1,
then array-enter the formula by pressing CTRL+SHIFT+ENTER
(instead of just pressing ENTER):

=INDEX(B:B,MAX(IF(ISBLANK(B1:B65535),0,ROW(B1:B65535))))

The above was taken from Bob Phillip's fine page at:
http://www.xldynamic.com/source/xld.LastValue.html#last_any