Posted to microsoft.public.excel.misc

external usenet poster

Posts: 22

top ten ranking

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Ranking	Excelicious	Excel Worksheet Functions	4	April 3rd 08 06:58 PM
Help with ranking	Stone	Excel Discussion (Misc queries)	6	March 24th 08 01:17 AM
Ranking	casdaq	Excel Worksheet Functions	0	March 28th 07 12:09 AM
Ranking	linzi00	Excel Discussion (Misc queries)	2	October 5th 06 05:42 PM
ranking	tagraeff	Excel Worksheet Functions	4	October 26th 05 11:59 AM

All times are GMT +1. The time now is 02:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us