Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting
Any one know of a way to sort by 4 key's
Key1:=Range("N2"), Order1:=xlAscending, Key2:=Range("A2"), Order2:=xlAscending, Key3:=Range("S2"), Order3:=xlAscending, Key4:=Range("T2"), Order4:=xlAscending, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting
Two sorts are required. Sort first by Key #4 (T2). Then sort a 2nd time with 3
keys, #1 = N2, #2 = A2, #3 = S2 On Tue, 25 Jan 2005 18:37:31 -0800, "Patrick Simonds" wrote: Any one know of a way to sort by 4 key's Key1:=Range("N2"), Order1:=xlAscending, Key2:=Range("A2"), Order2:=xlAscending, Key3:=Range("S2"), Order3:=xlAscending, Key4:=Range("T2"), Order4:=xlAscending, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting
How about adding another column say 'Z' and concatenate the other 4 columns
and then doing one sort on 'Z'? Z2 = +N2 & A2 & S2 & T2 Chris "Patrick Simonds" wrote in message ... Any one know of a way to sort by 4 key's Key1:=Range("N2"), Order1:=xlAscending, Key2:=Range("A2"), Order2:=xlAscending, Key3:=Range("S2"), Order3:=xlAscending, Key4:=Range("T2"), Order4:=xlAscending, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Values Without Sorting Formulas | Excel Discussion (Misc queries) | |||
Automatic sorting (giving max and min) based on custom sorting lis | Excel Worksheet Functions | |||
Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
Sorting: Sorting by the First Character | Excel Discussion (Misc queries) | |||
Sorting ListBox results or transposing ListBox values to other cells for sorting | Excel Programming |