| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotal, then sort groups by their subtotals
This seems like it should be an easy question, but is there a way to subtotal
by an amount, then sort the groups by that amount? i.e. get total Acct. Receivable Balance by customer, then sort the customer groups so that the customer with the highest receivable balance is on top? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtotal, then sort groups by their subtotals
Try this:
Collapse the data range to show only the subtotals THEN sort by balance When you expand the groups, you'll see that the data moved with the subtotals during the sort. Does that help? *********** Regards, Ron XL2003, WinXP "Lorenda" wrote: This seems like it should be an easy question, but is there a way to subtotal by an amount, then sort the groups by that amount? i.e. get total Acct. Receivable Balance by customer, then sort the customer groups so that the customer with the highest receivable balance is on top? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort subtotal groups | Excel Worksheet Functions | |||
| why do the groups not show when i subtotal? | Excel Discussion (Misc queries) | |||
| Subtotals: Nested subtotals below higher subtotal | Excel Discussion (Misc queries) | |||
| keyboard shortcut 4 moving btwn subtotals groups. | Excel Discussion (Misc queries) | |||
| How do I make subtotals appear directly below groups with spaces b | Excel Discussion (Misc queries) | |||
Linear Mode
