| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting array function explanation please
I searched previous posts for a formula that could sort a column of
text values and found this gem, which I have adapted to sort a range named AList. The original formula was supplied by Harlan Grove in Jun 2004... =INDEX(AList,MATCH(SMALL(COUNTIF(AList,"<"&AList)+ COUNT(AList),ROW()- ROW($E$1)+1),COUNTIF(AList,"<"&AList)+COUNT(AList) ,0)) This array formula works perfectly; however, I am having trouble understanding how it works. The SMALL functions first argument, COUNTIF(AList,"<"&AList) +COUNT(AList), has to return an array. This is the bit I cant understand. Can anyone explain for me how COUNTIF(AList,"<"&AList)+COUNT(AList) manages to return an array for the SMALL functions first argument? Ken Johnson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Complex Array sorting issue | Excel Worksheet Functions | |||
| sorting array formula | Excel Worksheet Functions | |||
| Problems when sorting data containing array formulas | Excel Worksheet Functions | |||
| Sorting within an array | Excel Discussion (Misc queries) | |||
| Explanation of when & how to use ( ) { } : ; , ! etc? | New Users to Excel | |||
Threaded Mode
