| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Arrays/Functions/Different datatypes in a formula? | Excel Worksheet Functions | |||
| Excel functions which support arrays (SHIFT-CNTRL-ENTER)? | Excel Worksheet Functions | |||
| Arrays parameters in Functions | Excel Worksheet Functions | |||
| Data calculations require more than 7 nested functions | Excel Worksheet Functions | |||
| Data calculations require more than 7 nested functions | Excel Worksheet Functions | |||
Threaded Mode
