Populate a cells value with the previous value of another cell
I am looking to have a rolling history of values. I want the cell to the right to have the previous value of the cell to the left. In other words, if I update the left cell, I want the left cells old value to move over the right cell? I cant seem to find a way to do this.
Help Article Resources
Check out the Formula Handbook template!