| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Do a data sort to more levels at once
Is there a technique or add-on software or utility that will let me do a Data Sort in excel by 4 or more levels at once. Currently you can only do 3 levels at once. I'd rather not have to separate the files after the first sorting operation, in order to sort more types of fields. -- Pam LaDue ------------------------------------------------------------------------ Pam LaDue's Profile: http://www.excelforum.com/member.php...o&userid=36773 View this thread: http://www.excelforum.com/showthread...hreadid=564874 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Do a data sort to more levels at once
Why not concatenate the 4 fields together and sort on that one field. You'll have to be a bit careful how you do this otherwise you wont end up with things in the order you want, but this might work -- Special-K ------------------------------------------------------------------------ Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470 View this thread: http://www.excelforum.com/showthread...hreadid=564874 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Do a data sort to more levels at once
I don't understand when you say "separate the files".
Simply select your *entire* datalist, then perform a sort on the least (last) sort key. Now, just do it (the sort) again, with your 3 remaining sort keys in the proper order (1st, 2nd, 3rd). No need to do *anything* between the sorts. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Pam LaDue" wrote in message ... Is there a technique or add-on software or utility that will let me do a Data Sort in excel by 4 or more levels at once. Currently you can only do 3 levels at once. I'd rather not have to separate the files after the first sorting operation, in order to sort more types of fields. -- Pam LaDue ------------------------------------------------------------------------ Pam LaDue's Profile: http://www.excelforum.com/member.php...o&userid=36773 View this thread: http://www.excelforum.com/showthread...hreadid=564874 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Do a data sort to more levels at once
There's a program called DigDB. Try this web address: http://www.digdb.com/excel_add_ins/s...ltiple_levels/ It may be of some help. Have a great day! -- jr100 ------------------------------------------------------------------------ jr100's Profile: http://www.excelforum.com/member.php...o&userid=31335 View this thread: http://www.excelforum.com/showthread...hreadid=564874 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Do a data sort to more levels at once
Just do the sorting multiple times.
Do the 3 most important fields last. Pam LaDue wrote: Is there a technique or add-on software or utility that will let me do a Data Sort in excel by 4 or more levels at once. Currently you can only do 3 levels at once. I'd rather not have to separate the files after the first sorting operation, in order to sort more types of fields. -- Pam LaDue ------------------------------------------------------------------------ Pam LaDue's Profile: http://www.excelforum.com/member.php...o&userid=36773 View this thread: http://www.excelforum.com/showthread...hreadid=564874 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort source workbook data, maintain formulas in destination workb. | Excel Worksheet Functions | |||
| Match and Sort for two range of data on different worksheets? | New Users to Excel | |||
| macro to sort data in worksheet by specific date | Excel Discussion (Misc queries) | |||
| sort column data with hidden columns - excel 2003 | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Linear Mode
