Hello,
Am I able to set up a formula that auto-updates when I input data into a different cell?For example:
In the file I have uploaded, each week I input a new number. The formula that calculates WoW change is based upon the new weeks number I manually input. Is there a way that the formula auto-updates, so that the WoW percentage changes automatically, only when I input the new week number?
I would like the formula that generates 43%, (week47 over week46), to auto update when I input the number for week 48, (week48 over week47). Currently, I manually change the cell number within the formula after having input the new data.
The version of excel I use is Microsoft Office 365, Windows 10
Any help/advice is greatly appreciated.