hi guys, this is my problem:
in column A: vehicle no ( there are 10 vehicles)
column B: start km
column c : end km
clm D: km travelled
in clumn e: date
in clm f : tyre replacement: 1,2,3,4,5 (can choose and number is the location of the tyres)
now i wan to use a formula to return the cumulative distance travelled by a vehicle when tyre of the same location is changed.(e.g location 1).
i wan to know how long a tyre ( for a certain location ) can last after travelling for how many kilometres. (and it have to be the same vehicle no!)
the scenario:
vehicle no start km end km tyre replacement(if any)
x1234 45 67 1
z4567 37 65
x1234 67 85
z4567 65 100 3
x1234 85 112 1
result :112-67=
The key to this problem is that if one month later, x1234 has tyre change at 1 and the end km is recorded at 250( e.g) The result wil be 250-112
Bookmarks