Hi,
Canoot make any sense from the data layout. Anyways, pivots have a feature
for Sort and Top 10

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Selj" wrote in message
...
I have spreadsheet similar to this:

Week 1 Week 2
Name Singles Handicap Singles Handicap %
Grp 1
Dave 23 23 17 18 81.0%
Jim 25 25 21 22 93.0%
Brad 14 12 18 18 62.0%
Moritz 20 13 22 21 76.0%
Bob 25 24 22 19 90.0%



Grp 2
Gary 16 19 23 23 81.0%
Tony 17 19 25 24 85.0%
Gary 19 19 14 12 64.0%
Frank 23 20 20 13 76.0%
Mike 22 19 25 24 90.0%

I need to know which 5 people have the top percentage. This is scaled
down
version of the spreadsheet. There are a lot more groups and I need to
keep
the space between the groups for other data. There are also more weeks
(10).

I've tried lists but it won't let me use multiple selections.