Which Excel Functions Require Arrays to be Sorted?
 

Can anyone tell me which Excel functions require sorted ascending arrays.
For example, I know that the Lookup function only works if the array it looks
at is sorted in ascending fashion:

LOOKUP(LookupValue, Ascending Array)

Are there any other which require this?

Thanks

EM

Which Excel Functions Require Arrays to be Sorted?
 

MATCH, VLOOKUP and HLOOKUP don't require that things be sorted in any order
*if* you use the optional arguments to look for an exact match. If you want
approximate matches (the default, i believe, in all cases) then a sort order
is necessary.

Afaik, LOOKUP is the only function that requires sorted data under any
circumstance.

HTH,


"ExcelMonkey" wrote in message
...
Can anyone tell me which Excel functions require sorted ascending arrays.
For example, I know that the Lookup function only works if the array it
looks
at is sorted in ascending fashion:

LOOKUP(LookupValue, Ascending Array)

Are there any other which require this?

Thanks

EM