How to Find

[Rohinikumar]

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

 

[Jacob Skaria]

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

 

[Rohinikumar]

Hi Jacob thx for quickly reply....but its not working i mean they are
mentioned less kilometre in oening KM insted of correct i mean closing is 30
but they mentioned starting 28 unnesosrly we have to paid for two KM.can you
help me.

 

[Jacob Skaria]

Are you sure you entered as array formula. (Shift+Ctrl+Enter) instead of Enter