With data in ColA:C try the below.,

Please note that this is an array formula. You create array formulas in the
same way that you create other formulas, except you press CTRL+SHIFT+ENTER to
enter the formula. If successful in 'Formula Bar' you can notice the curly
braces at both ends like "{=<formula}"

=MAX(IF(A1:A10=2415,C1:C10))-MIN(IF(A1:A10=2415,B1:B10))+1

--
Jacob


"Rohinikumar" wrote:

Hi some one can help i think...
that the i have vehicle details i mean starting kilometre and closing
kilometre but some time that drivers are cheated like below i mean they
mentioned one or two numbers before.
Cab No St KM Cl KM
2415 12 15
2415 14 18
2415 18 25
2415 24 29
2415 28 31

How to find this exat kilometre