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