Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match function problem
All,
I was trying to use the match function on a non-sorted array. Using the final option to be 1 and I am getting funny results depending on the size of the array that I pass ... the array that I using is pasted below and starts at cell B1 in my worksheet: 6.247097314 7.415613355 8.846348525 10.60682215 12.78346586 15.4868769 18.85815023 23.07605113 28.36417996 34.9960463 43.29364964 53.61114205 66.2889247 81.5557226 99.3510699 119.0507729 139.1278957 156.8977329 168.653679 170.5412546 160.1634496 138.146888 108.4363164 76.80743043 48.54755565 26.82511268 12.41893668 4.386490402 4.386490402 4.386490402 The formula is : Match(125,$b$1:$b$30,1)... this formula leads to 30. But if I enter the formula as Match(125,$b$1:$b$29,1) it results in 16 which is the correct value. Even though I am not adding any new values at the end (the last 3 values in the array are the same) .. I am getting a different answer each time ! Has this happened to someone before? Any thoughts?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
MATCH function problem | Excel Discussion (Misc queries) | |||
numerical integration | Excel Discussion (Misc queries) | |||
Double and Multiple Lookup Using the MATCH Function | Excel Worksheet Functions | |||
Lookup function problem (kg) | Excel Worksheet Functions |