HI Jacob thx its working and i have one more doubt that how can i find which
vehicle reduce the KM and how to highlight the cab NO

"Jacob Skaria" wrote:

You have not applied the formula as an array formula..Use Shift+Ctrl+Enter
instead of Enter to apply the formula. The below array formula; if applied in
cell E1 will calculate the total kilometeres done for the vehicle number
mentionedin cell A1

For example maxkilmoter done by vehicle 2415 is 51; min done is 12 so the
total kilometers done by the vehile is 51-12+1 = 40

=MAX(IF($A$1:$A$100=A2,$C$1:$C$100))-
MIN(IF($A$1:$A$100=A2,$B$1:$B$100))+1

--
Jacob


"Rohinikumar" wrote:

Hi Jacob i tried as you said but it shown like below

Veh NO ST KM CL KM Total KM 1
2415 12 19 7 88
2517 15 21 6 1
8521 18 25 7 1
2415 17 29 12 85
7895 25 45 20 1
2415 27 51 24 85
1245 45 60 15 1
2517 87 99 12 1
8521 15 25 10 1
3654 17 22 5 1
7895 28 36 8 1
3157 31 48 17 1

how can i highlight and how can i find howmany kM they reduced insted of
correct?
"Jacob Skaria" wrote:

The formula posted yesterday will give you the actual total kilometers done
by a vehicle (excluding the wrong entries). Try that as an array formula

--
Jacob


"Rohinikumar" wrote:

Hi some one can help i think...
That the i have a vehicle details sheet i mean starting kilometre and closing
kilometres, but some time that drivers are cheated like below i mean they are
mentioned less kilometre insted of correct, i mean closing K.M is 30
but they are mentioned starting 28 unnesosrly we have to paid for two
KM.some one can help me how to find minus Kilometres.

Veh NO ST KM CL KM Total KM
1245 12 19 7
2517 15 21 6
8521 18 25 7
3654 21 29 8
7895 25 45 20
3157 32 51 19
1245 45 60 15
2517 87 99 12
8521 15 25 10
3654 17 22 5
7895 28 36 8
3157 31 48 17