| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting a subtotal list by the subtotals
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting a subtotal list by the subtotals
copy out the subtotals by highlighting them, then Edit/go to/Special/visible
cells only, then copy and paste "Ken W" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting a subtotal list by the subtotals
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. -- HTH... Jim Thomlinson "Ken W" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotal, then sort groups by their subtotals | Excel Worksheet Functions | |||
| Subtotals not working correctly when 2nd subtotal added | Excel Worksheet Functions | |||
| Subtotals: Nested subtotals below higher subtotal | Excel Discussion (Misc queries) | |||
| Subtotal results in new column and then sorting subtotals | Excel Worksheet Functions | |||
| Sorting a list with subtotals | Excel Worksheet Functions | |||
Hybrid Mode
