Forum Discussion
Subtracting from one cell
So I have AI2. I want the red column to represent the "points behind" of the numbers in column Blue from AI2. I could just go =AI2-AI3 and so on but that'd be time-consuming. Is there a formula to...
I would convert your data into an Excel table (Ctrl + T).
You can still use your formula and when you add new data it will auto populate.