View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dnamertz dnamertz is offline
external usenet poster
 
Posts: 5
Default How do I Subtotal, then Sort by Subtotal Amounts?

I have a few thousand row of part numbers with their costs (many part numbers
appear on multiple rows) and I have sorted them by part number, then I
subtotalled the cost column. Now I want to sort them by the subtotal amount,
so the part number group with the highest cost subtotal is first, but I want
to keep the detail in tact. How do I do this?