Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Multilevel Sorting?
Is there a way to get around the 3 level limit in sortng. Want to sort by 4
sets to 4 levels or more. |
#2
|
|||
|
|||
Not in one fell swoop, first sort the least significant etc
assume you would sort by columns A, B, C and D (in that order of significance) select C:D and sort in that order, then select A:D and sort by A -- Regards, Peo Sjoblom "Mike" wrote in message ... Is there a way to get around the 3 level limit in sortng. Want to sort by 4 sets to 4 levels or more. |
#3
|
|||
|
|||
Sort the least significant column first, then sort on the most
significant 3. In article , "Mike" wrote: Is there a way to get around the 3 level limit in sortng. Want to sort by 4 sets to 4 levels or more. |
#4
|
|||
|
|||
Hi, Peo:
If the data requires 4 columns, A:D, I don't think you want to "select C:D and sort" do you? That will uncouple the data in columns C and D from that in columns A and B. I think you mean to select columns A:D, sort on D (or C and D), then with A:D still selected, sort on A, B, and C (or A and B). No? On Mon, 18 Apr 2005 06:40:36 -0700, "Peo Sjoblom" wrote: Not in one fell swoop, first sort the least significant etc assume you would sort by columns A, B, C and D (in that order of significance) select C:D and sort in that order, then select A:D and sort by A |
#5
|
|||
|
|||
Correct, meant select all columns and sort by the least significant first
Thanks -- Peo Sjoblom "Myrna Larson" wrote in message ... Hi, Peo: If the data requires 4 columns, A:D, I don't think you want to "select C:D and sort" do you? That will uncouple the data in columns C and D from that in columns A and B. I think you mean to select columns A:D, sort on D (or C and D), then with A:D still selected, sort on A, B, and C (or A and B). No? On Mon, 18 Apr 2005 06:40:36 -0700, "Peo Sjoblom" wrote: Not in one fell swoop, first sort the least significant etc assume you would sort by columns A, B, C and D (in that order of significance) select C:D and sort in that order, then select A:D and sort by A |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
sorting number in ascending order | Excel Discussion (Misc queries) | |||
SORTING question | New Users to Excel | |||
Adding a KeyID column for sorting | New Users to Excel | |||
sorting question | Excel Discussion (Misc queries) |