| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I Subtotal, then Sort by Subtotal Amounts?
I have a few thousand row of part numbers with their costs (many part numbers
appear on multiple rows) and I have sorted them by part number, then I subtotalled the cost column. Now I want to sort them by the subtotal amount, so the part number group with the highest cost subtotal is first, but I want to keep the detail in tact. How do I do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I Subtotal, then Sort by Subtotal Amounts?
With your existing data in sheet1, Sub-totaled (level2-being currentlyselected)
I Highlight the full range - Edit, Goto, Special Cells button... Visible-Cells Only select then Copy then go to or add sheet2 (Should be Blank) and Paste Then on sheet2 Datat, Sort., Cost << Desending Your Sheet1 data is INTACT HTH "dnamertz" wrote: I have a few thousand row of part numbers with their costs (many part numbers appear on multiple rows) and I have sorted them by part number, then I subtotalled the cost column. Now I want to sort them by the subtotal amount, so the part number group with the highest cost subtotal is first, but I want to keep the detail in tact. How do I do this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I Subtotal, then Sort by Subtotal Amounts?
If you collapse the outline to only display the subtotals,
you can select the entire outlined range (excluding the grand total) and peform the sort. The detail data within the collapsed subtotals will move with the subtotal and those details will remain in the same order. (at least that's how XL2002 worked when I just tested it) Does that help? *********** Regards, Ron XL2002, WinXP "dnamertz" wrote: I have a few thousand row of part numbers with their costs (many part numbers appear on multiple rows) and I have sorted them by part number, then I subtotalled the cost column. Now I want to sort them by the subtotal amount, so the part number group with the highest cost subtotal is first, but I want to keep the detail in tact. How do I do this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I Subtotal, then Sort by Subtotal Amounts?
Thanks, that helped.
"Ron Coderre" wrote: If you collapse the outline to only display the subtotals, you can select the entire outlined range (excluding the grand total) and peform the sort. The detail data within the collapsed subtotals will move with the subtotal and those details will remain in the same order. (at least that's how XL2002 worked when I just tested it) Does that help? *********** Regards, Ron XL2002, WinXP "dnamertz" wrote: I have a few thousand row of part numbers with their costs (many part numbers appear on multiple rows) and I have sorted them by part number, then I subtotalled the cost column. Now I want to sort them by the subtotal amount, so the part number group with the highest cost subtotal is first, but I want to keep the detail in tact. How do I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting data on protected worksheet | Excel Discussion (Misc queries) | |||
| Nested subtotal display error | Excel Discussion (Misc queries) | |||
| How can I sort multiple times | Excel Worksheet Functions | |||
| Using more than one subtotal with same data set | Excel Worksheet Functions | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Linear Mode
