Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
"kcc" wrote...
.... Out of force of habit, I would use =MIN(IF(E2:E14&G2:G14=A17&B17,A2:A14)) .... Are there any tests/studies of excel performance for various functions and/or formula structure? Roll your own tests. It's not that hard. Generally text operations take more time than arithmetic operations, and concatenation is especially time consuming. Also, which this approach probably wouldn't cause problems with the OP's data, it's not robust in general. If both columns E and G were arbitrary text, there's the chance that E#<A17 and G#<B17 but E#&G#=A17&B17. Once you add a concatenated separator on each side of the comparison you're not saving much typing and it's very unlikely you're doing anything other than wasting cycles. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Array formula SUMIF with 2D sum_range array | Excel Worksheet Functions | |||
Array formula: how to join 2 ranges together to form one array? | Excel Worksheet Functions | |||
Find specific value in array of array formula | Excel Worksheet Functions | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
Array Formula - using LEFT("text",4) in formula | Excel Worksheet Functions |