| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
| where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
| Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
| 'find' somtimes can't find numbers. I folowd the 'help' instructi. | Excel Worksheet Functions | |||
| How do I find a file/spreadsheet that Excel says is Already open but I can't find it? | Excel Discussion (Misc queries) | |||
Linear Mode
