[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]TIRE ID[/TD]
[TD]VEHICLE NO.[/TD]
[TD]ODOMETER[/TD]
[TD]KM RUN[/TD]
[TD]TOTAL KM RUN[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RH12[/TD]
[TD]9012[/TD]
[TD]543[/TD]
[TD]543[/TD]
[TD]NIL[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RH12[/TD]
[TD]9012[/TD]
[TD]754[/TD]
[TD]754-543[/TD]
[TD]211[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RH12[/TD]
[TD]9012[/TD]
[TD]998[/TD]
[TD]998-754[/TD]
[TD]211+244[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RH12[/TD]
[TD]9032[/TD]
[TD]4530[/TD]
[TD]211+244[/TD]
[TD]211+244[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RH12[/TD]
[TD]9032[/TD]
[TD]4989[/TD]
[TD](4989-4530)+211+244[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RH12[/TD]
[TD]9043[/TD]
[TD]232[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RH12[/TD]
[TD]9043[/TD]
[TD]357[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
SOMEBODY PLS HELP ME IN FINDING OUT THE SOLUTION OF PROBLEM.
I NEED EXCEL TO FIND WHETHER I TIRE IS FITTED ON SAME VEHICLE,IF YES THEN IT CALCULATES KM RUN IN THAT VEHICLE.
EXAMPLE FOR 9012 I NEED IT TO REFLECT TOTAL KM RUN IN THAT VEHICLE THEN IN 9032 AND SO ON FOR EVERY VEHICLES.
<tbody>[TR]
[TD]TIRE ID[/TD]
[TD]VEHICLE NO.[/TD]
[TD]ODOMETER[/TD]
[TD]KM RUN[/TD]
[TD]TOTAL KM RUN[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RH12[/TD]
[TD]9012[/TD]
[TD]543[/TD]
[TD]543[/TD]
[TD]NIL[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RH12[/TD]
[TD]9012[/TD]
[TD]754[/TD]
[TD]754-543[/TD]
[TD]211[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RH12[/TD]
[TD]9012[/TD]
[TD]998[/TD]
[TD]998-754[/TD]
[TD]211+244[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RH12[/TD]
[TD]9032[/TD]
[TD]4530[/TD]
[TD]211+244[/TD]
[TD]211+244[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RH12[/TD]
[TD]9032[/TD]
[TD]4989[/TD]
[TD](4989-4530)+211+244[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RH12[/TD]
[TD]9043[/TD]
[TD]232[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RH12[/TD]
[TD]9043[/TD]
[TD]357[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
SOMEBODY PLS HELP ME IN FINDING OUT THE SOLUTION OF PROBLEM.
I NEED EXCEL TO FIND WHETHER I TIRE IS FITTED ON SAME VEHICLE,IF YES THEN IT CALCULATES KM RUN IN THAT VEHICLE.
EXAMPLE FOR 9012 I NEED IT TO REFLECT TOTAL KM RUN IN THAT VEHICLE THEN IN 9032 AND SO ON FOR EVERY VEHICLES.