Sorting a subtotal list by the subtotals

  • Thread starter Thread starter Ken W
  • Start date Start date
K

Ken W

Is there some way that I can sort the totals of a list and leave the
underlying data there, or do I need to copy out the summarize data and then
sort that?
 
copy out the subtotals by highlighting them, then Edit/go to/Special/visible
cells only, then copy and paste
 
Are you creating your subtotals using Insert -> Subtotals. If so then you
could create a pivot table instead. That would allow you to sort by the
subtotaled amounts.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting and subtotal in a filtered list 1
Sorting Subtotals 11
How do I sort pivot table data by subtotals? 2
Getting Text data using the Data - Subtotal feature 1
Conditional SUBTOTAL in XL210 Table 7
subtotal within subtotal 5
Sorting by Sub-Totals 2
sort macro, subtotal and add lines after subtotal 1

Back
Top