Keeping the Previous Value of a Cell

[ajcormac]

Hi,

I have two cells: Current and Previous.
I would like to set up Previous so that it retains the previous value of Current whenever Current changes.

For example: If Current is 2 and I change Current to 3, Previous would be set to 2
Formulas would be the preferred solution but I am open to any thoughts. Thanks!

[Tony Valko]

It's possible with formulas but you need to use several intermediate formulas to get to the final result.

There is a sample file here:

http://www.oaltd.co.uk/excel/

Scroll down about 1/4 of the way and look for: Previous.zip