Prev: Calculate times between dates and times in Excel
Next: Pivot Table Default Setting
From: liem on 24 Mar 2010 21:12
I have 20 category in each category I have random 1 to 500 items with sales
units and Sales $ metric for each items.

How can filter and rank it will show up top 10 items of combination for
Sales Units and Sales $
Cat 10 Item Sale units Sales $ Rank
bread 10 12
Cake 12 20
Cookies 8 10
"" "" ""
"" "" ""
Cat 12 Coke 120 135
Pepsi 129 132
Dr Pepper 190 198
orange 98 178
"" "" ""
Cat 13 Book1 120 201
Book 2 150 230
Book 3 145 245
Book 4 256 278
Thanks
Liem


--
thanks
 | 
Pages: 1
Prev: Calculate times between dates and times in Excel
Next: Pivot Table Default Setting