LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Find the top 10 from multiple groups.

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Creating stacked bar for multiple groups and multiple years James Charts and Charting in Excel 2 November 14th 08 05:18 PM
Multiple Criteria to Classify groups Karoline Excel Worksheet Functions 11 July 6th 08 11:36 AM
How to find a third true-false relationship between three groups ofvariables knowing two Edu Excel Worksheet Functions 5 January 22nd 08 09:41 PM
How to find the right discussion groups for Microsoft Support? Eric Excel Discussion (Misc queries) 1 January 30th 06 05:12 AM
find the max values for cells in consecutive groups of 600 john Excel Discussion (Misc queries) 2 October 4th 05 10:52 AM


All times are GMT +1. The time now is 09:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"