Solved Excel Difference Calc within a Column

September 25, 2011 at 09:52:00
Specs: OS X Lion
Hi I have a spreadsheet I update daily for my vehicles mileage. In the first column lets call it A I keep track of my daily end of day mileage. Is there a formula that will allow excel to automatically calculate the difference from the first mileage (A2) which will alway be a constant to the newest updated mileage that I input on a daily basis to find the difference of the total amount of mileage driven. I have been manually updating the formula and so far it seems a hassle it'd be awesome if excel could do this automatically whenever i inputed a new number in it would calculate difference the most current mileage to the constant first mileage.

See More: Excel Difference Calc within a Column

Report •

September 25, 2011 at 10:33:01
Perhaps I'm oversimplifying this; or maybe I just don't understand the question.

A1 - daily mileage
A2 - first mileage
A3 - enter the formula =A2-A1

That will give you the difference.

Report •

September 25, 2011 at 13:35:49
No, everything is listed in one column in descending order of mileage.
Basically I want excel to automatically calculate the difference from the newest entry i input to the original mileage.

This is what it looks like

The original mileage being the first mileage which is A2. Does that make sense? I did the way you mentioned for quite a while but I just want something automated, a formula that automatically update telling me total amount of miles driven.

Report •

September 26, 2011 at 00:58:53
✔ Best Answer
maybe this will work:
a1 mileage this month =large(a3:a33,1)-a2
a2 mileage starting
a3 miles at end of day1
a33 miles at end of day 31

Report •

Related Solutions

September 26, 2011 at 01:25:27
That worked flawlessly, Thanks!

Report •

Ask Question