# 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

#1
September 25, 2011 at 10:33:01
 Perhaps I'm oversimplifying this; or maybe I just don't understand the question.A1 - daily mileageA2 - first mileageA3 - enter the formula =A2-A1That will give you the difference.

Report •

#2
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 likeThe 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 •

#3
September 26, 2011 at 00:58:53