View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rtwoi rtwoi is offline
external usenet poster
 
Posts: 3
Default How do I sort subtotals for groups in Excel ?

I have a spreadsheet with lists of telephone calls and their cost.
I want to group calls to the same number together and get the total cost of
these calls. I then want to sort the groups into descending order of cost.

Both the subtotals facility and the Pivot table facility allow me to group
and sum the cost of the calls but I cannot then find a way to sort the
results in descending order of total cost. I am trying to find out what
called numbers have the highest total cost.

I am using Excel 2002.