Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
subtotals
I have subtotals in a worksheet and would like to now organize the worksheet
so that the subtotalled data is in greatest to lowest or lowest to greatest order. But I want not only the subtotal data to show but also the individuals rows that make up the data. See below: Kerry Smith 9/1/07 Inv 712 $200.00 Kerry Smith 10/1/07 Inv 740 $200.00 Kerry Smith 11/1/07 Inv 760 $200.00 Kerry Smith 12/1/07 Inv 780 $200.00 Kerry Smith $800.00 Joe Aimes 10/1/08 Inv 900 $300.00 Joe Aimes 10/1/08 Inv 900 $300.00 Joe Aimes $600.00 Bill Jones 1/1/07 Inv 670 $200.00 Bill Jones $200.00 Any help would be much appreciated. Thank you, CC |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
subtotals
There is no easy way to do that with subtotals. It is easy with a pivot table
if you are ok with the idea... Remove the subtotals. Select the data area. Select Data - Pivot Tables - Follow the Wizard. Right click the names and select Field Settings. Select Advanced and then change the sort order to by subtotal... -- HTH... Jim Thomlinson "CC" wrote: I have subtotals in a worksheet and would like to now organize the worksheet so that the subtotalled data is in greatest to lowest or lowest to greatest order. But I want not only the subtotal data to show but also the individuals rows that make up the data. See below: Kerry Smith 9/1/07 Inv 712 $200.00 Kerry Smith 10/1/07 Inv 740 $200.00 Kerry Smith 11/1/07 Inv 760 $200.00 Kerry Smith 12/1/07 Inv 780 $200.00 Kerry Smith $800.00 Joe Aimes 10/1/08 Inv 900 $300.00 Joe Aimes 10/1/08 Inv 900 $300.00 Joe Aimes $600.00 Bill Jones 1/1/07 Inv 670 $200.00 Bill Jones $200.00 Any help would be much appreciated. Thank you, CC |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotals problem: Excel 2003 (not, AFAIK, the nested subtotals bug) | Excel Discussion (Misc queries) | |||
Original subtotals should not be within nested subtotals in excel | Excel Worksheet Functions | |||
Subtotals: Nested subtotals below higher subtotal | Excel Discussion (Misc queries) | |||
How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
Problem with nested subtotals, placing secondary subtotals BELOW . | Excel Discussion (Misc queries) |