Home

Subtracting from one cell

MianoZanVero
Occasional Visitor

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.  

2 Replies

@MianoZanVero 

 

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.

@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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
description for autoplay blocking in settings page
HotCakeX in Discussions on
8 Replies