| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW CAN I SORT SUBTOTALS FROM HIGHEST TO LOWEST
-- JG |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HOW CAN I SORT SUBTOTALS FROM HIGHEST TO LOWEST
If you used data|subtotals to apply the subtotals, then use the outlining
symbols to the left to hide the detail rows and sort the data by the field you want. JGAVIGAN wrote: -- JG -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HOW CAN I SORT SUBTOTALS FROM HIGHEST TO LOWEST
go to the view where you just see the subtotals, highlight what you want to
sort, on the menu bar: Edit / Go to / Special / Visible Cells Only then Edit / Copy, then paste into another sheet. You can now sort that as usual "JGAVIGAN" wrote: -- JG |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum (throw out highest and lowest) | Excel Worksheet Functions | |||
| Graph Highest to Lowest. | Excel Discussion (Misc queries) | |||
| How do I sort ascend from highest to lowest | Excel Discussion (Misc queries) | |||
| Sort from lowest to highest | Excel Worksheet Functions | |||
| How do i sort a group of cells from highest to lowest | Excel Discussion (Misc queries) | |||
Linear Mode
