A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

ranking



 
 
Thread Tools Display Modes
  #1  
Old May 28th, 2010, 08:34 PM posted to microsoft.public.excel.worksheet.functions
liem
external usenet poster
 
Posts: 22
Default ranking

How can I rank the top 5 or 10 items in the category for a location.
Location PSA Category item Day 1 day 2 day 3 day 4 day 5 day 6
1501 17 Grill Hot dog 10 12 3 8
11 7
1501 17 Grill Hot Link 3 11 12 11
5 3
1501 17 grill Corn dog 11 14 12 6 4
8
1501 17 Bakery Donut 6 8 5 8
7 9
1501 17 Bakery Eclair 8 5 7 8
10 6
1501 17 Bakery Chocolate 10 7 11 9 5
8
1501 17 Bakery Cookie 12 6 8 10 8
9
1501 17 Bakery Plain Donut 8 10 5 8 6
7
1501 17 Bakery Boston Ck 6 5 8 7 6
5

each category can have over humderd items and I only want top 5 or top 10
item show up.


thanks
  #2  
Old May 28th, 2010, 08:39 PM posted to microsoft.public.excel.worksheet.functions
Luke M[_4_]
external usenet poster
 
Posts: 451
Default ranking

Use a PivotTable, and then a Top x filter?

--
Best Regards,

Luke M
"liem" wrote in message
...
How can I rank the top 5 or 10 items in the category for a location.
Location PSA Category item Day 1 day 2 day 3 day 4 day 5 day
6
1501 17 Grill Hot dog 10 12 3 8
11 7
1501 17 Grill Hot Link 3 11 12 11
5 3
1501 17 grill Corn dog 11 14 12 6
4
8
1501 17 Bakery Donut 6 8 5 8
7 9
1501 17 Bakery Eclair 8 5 7 8
10 6
1501 17 Bakery Chocolate 10 7 11 9 5
8
1501 17 Bakery Cookie 12 6 8 10
8
9
1501 17 Bakery Plain Donut 8 10 5 8
6
7
1501 17 Bakery Boston Ck 6 5 8 7
6
5

each category can have over humderd items and I only want top 5 or top 10
item show up.


thanks



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:58 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.