View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] dmckaig2002@gmail.com is offline
external usenet poster
 
Posts: 3
Default Excel - Sorting groups in groups due to subtotaling

I need to know how to sort numbers in groups when they are within
groups due to subtotaling.
I want to be able to sort each company by descending order by Sales
number.
Here is an example:

Customer Name Product Name Sales
ABC Company Product 1 880
Product 2 220
Product 3 400
Subtotal 1,420
DEF Company Product 1 700
Product 2 1,250
Product 3 100
Subtotal 2,050

I need to know (as they say) yesterday, if anyone can help!!!!!
Thanks!