Which Excel Functions Require Arrays to be Sorted?

[Guest]

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

 

[George Nicholson]

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,