Try using a pivot table, and do grouping within the pivot table.

Thanks.
--
when u change the way u look @ things, the things u look at change.


" wrote:

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!