automatic subtraction

[legolas]

Dear all,

I'm trying to prepare vehicle mileage report based on vehicle number (column B) and date (A) , pls see attached
is it possible to have in E a formula to do the subtraction of last and first mileage in C based on same month in A ?

i just need to calculate how many kms a vehicle travelled each month

i hope it is clear enough and thanks for you usual help

 

[legolas]

full image

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Automatic subtraction
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[legolas]

where did i cross post the question ?

 

[Fluff]

You must know where you have already asked this question.

 

[Fluff]

Now posted here as well how to create formula for automatic subtraction
In future please supply links when you cross-post.