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.

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-A1That will give you the difference.

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

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

That worked flawlessly, Thanks!

Ask Your Question

Weekly Poll

How long do you think until flying cars or taxis are common?

Discuss in The Lounge

Poll History