ok some questions!!
do you or can you list more than 1 tyre location at the same time,and is the
'start KM and end km reset at the tyre change or do you need a new /separate
cell for the km at tyre change.....and will you therefore have a seperate km
box for each tyre???
--
paul
remove nospam for email addy!



"cjjoo" wrote:


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!)

can any one help me on this?


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