| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort 4 Columns
I want to sort 4 columns of data. A thru D. I want to sort by B then C then
D then A. Is this possible. The data sort feature only lets you do 3 at a time. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort 4 Columns
Do the sort twice.
The first sort with one key--the most minor. The second sort with the other 3 keys. Dot wrote: I want to sort 4 columns of data. A thru D. I want to sort by B then C then D then A. Is this possible. The data sort feature only lets you do 3 at a time. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort 4 Columns
I thought there was a modification that could be done to the sort tool, but
doing it twice will work. Thanks "Dave Peterson" wrote: Do the sort twice. The first sort with one key--the most minor. The second sort with the other 3 keys. Dot wrote: I want to sort 4 columns of data. A thru D. I want to sort by B then C then D then A. Is this possible. The data sort feature only lets you do 3 at a time. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort columns | Excel Worksheet Functions | |||
| sort by two columns ends up with wrong sort in 2nd col | Excel Discussion (Misc queries) | |||
| Sort command does not sort some columns? | New Users to Excel | |||
| How do I sort the data in 8 columns by two of the columns? | Excel Worksheet Functions | |||
| data sort is not including all columns in sort | Excel Discussion (Misc queries) | |||
Linear Mode
