okie ... sorry that i did not describe the question carefully.Here it
goes!


these informations are actually key in daily.And if we assume that
today, one

vehicle request for a tyre change. So the driver will key (in the tyre
replacement

column) the location that he needs the change. So i need a formula to
check

when was the last time that particular vehicle has changed a tyre (
with the

same location).The result should return the km the vehicle has
travelled during

the changing of the tyres interval. The start km and end km will not
reset as it is

key in by the drivers based on their gauge after the tyres have been
changed.

So can this question be solved with a formula?

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

Challenging? Hope someone can help me...


--
cjjoo
------------------------------------------------------------------------
cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916
View this thread: http://www.excelforum.com/showthread...hreadid=473695