Sorting by Sub-Totals

[carley brown]

I have a list of customers and items sold with qty's, sales dollars, etc. I
have subtotaled by customer. How can I sort the subtotals(which is the
sales) and have all the pertinent information get sorted along with the sub
totals.

 

[Jim Thomlinson]

I assume you have used Data -> Subtotals to insert your subtotals? if that is
the case then you are better off to remove those subtotals and create a pivot
table instead. A pivot table will allow you to sort by the subtotaled
amounts. There is no easy way to do that with subtotals.

 

[Jim Cone]

You can create a separate list of the subtotals and sort that...
1. Use the outline/grouping buttons and display just the subtotals.
2. Use Edit | Go To | Special (button) and select the Visible cells.
3. Copy the data and paste on another sheet.
4. Sort the data
--
Jim Cone
Portland, Oregon USA


"carley brown" <[email protected]>
wrote in message
I have a list of customers and items sold with qty's, sales dollars, etc. I
have subtotaled by customer. How can I sort the subtotals(which is the
sales) and have all the pertinent information get sorted along with the sub
totals.