Mar 17 2019 12:30 PM
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 pull this off quickly? Thank you.
Mar 27 2019 05:34 AM
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.
Mar 27 2019 06:39 AM
@MianoZanVero , other way you may add formula into AL3 (first in red), stay on it, Shift, click on AL25 or what is the end of your range (other words select red column) and press Ctrl+D.