| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array Sort on 2 keys
Hi All
I have an array with two dimensions, typically 36 by 2. Is there a procedure for sorting an array by the two variables in the second dimension? Or would it be simpler to write the array to a worksheet and use sort, then reload the array? -- Cheers Nigel |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Array Sort on 2 keys
You can do that with Laurent Longre's xll add-in:
http://xcell05.free.fr/ But maybe it is simpler to sort in a sheet. RBS "Nigel" wrote in message ... Hi All I have an array with two dimensions, typically 36 by 2. Is there a procedure for sorting an array by the two variables in the second dimension? Or would it be simpler to write the array to a worksheet and use sort, then reload the array? -- Cheers Nigel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Many Sort Keys | New Users to Excel | |||
| VBA Sort method w/more than 3 Keys | Excel Discussion (Misc queries) | |||
| sort list more than 3 keys? | Excel Programming | |||
| Need to know the Sort Column Keys | Excel Programming | |||
| Sort using 4 keys | Excel Programming | |||
Hybrid Mode
