|
How to Find
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 |
How to Find
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 |
How to Find
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" wrote: 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 |
How to Find
Are you sure you entered as array formula. (Shift+Ctrl+Enter) instead of Enter
-- Jacob "Rohinikumar" wrote: 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" wrote: 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 |
| All times are GMT +1. The time now is 12:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com