![]() |
HOW CAN I SORT SUBTOTALS FROM HIGHEST TO LOWEST
-- JG |
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 |
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 |
All times are GMT +1. The time now is 08:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com