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

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