Hi,

I have a value in A1 that continuously changes. However, after A1 has changed, I need the previous value in A1 to appear in A2 and when A1 changes again, I again need the previous value to appear in A2 and so on.

For example, if A1=1 and it changes to A1=2, then I need A2=1. Then, if A1=3, I need A2=2, etc.

I simply need the previous value in a particular cell to be stored in another cell. If somebody can help me with this problem it would be greatly appreciated.