| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting more than 3 columns
I would like to sort more than 3 columns. The tool provided by Excel onlyi
allows me to sort on three columns. Does anyone have any suggestions as to how I can do this? Thanks, Chad |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sorting more than 3 columns
You can do data|sort multiple times.
Start with the most minor fields and sort them (3 at a time), then the next 3 fields, then the next three, etc. Chad wrote: I would like to sort more than 3 columns. The tool provided by Excel onlyi allows me to sort on three columns. Does anyone have any suggestions as to how I can do this? Thanks, Chad -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sorting more than 3 columns
Chad wrote: I would like to sort more than 3 columns. The tool provided by Excel onlyi allows me to sort on three columns. Does anyone have any suggestions as to how I can do this? Thanks, Chad Chad, I'm sure you can find a solution that works for you in here. Google is your friend. http://groups.google.com/group/micro...rch+this+group Pierre |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting Excel columns in several worksheets at once. | Excel Discussion (Misc queries) | |||
| Macro sorting by 4 columns | Excel Discussion (Misc queries) | |||
| Sorting columns with expressions | New Users to Excel | |||
| sorting data across multiple columns | Excel Discussion (Misc queries) | |||
| Sorting rows AND columns | Excel Worksheet Functions | |||
Linear Mode
