Forum Discussion
MianoZanVero
Mar 17, 2019Copper Contributor
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...
SergeiBaklan
Mar 27, 2019Diamond Contributor
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.