Golf Handicaps

[Richard2542]

I have a list of 100 names with associated golf scores/handicaps. I need to develop 5 Flights (A, B, C, D, E) into which players will be placed based on their score/handicap, e.g., players who score par to 10 over par (this is a variable) would be placed into Flight A; Players 11 to ? would be in Flight B, etc. Ideally, we would have 20 players or thereabout per group. In addition, the range of scores/handicap by player may change each week resulting in a shift of players within given flights. This will be used for tournament play where each group of 4 players will have 1 A Player, 1 B Player, etc. to even out the field.

 

[NeonRedSharpie]

Re: Golf Handicps

=IF(RANK($A1,$A$1:$A$100)/COUNTA($A$1:$A$100)<=0.2,"E",IF(RANK($A1,$A$1:$A$100)/COUNTA($A$1:$A$100)<=0.4,"D",IF(RANK($A1,$A$1:$A$100)/COUNTA($A$1:$A$100)<=0.6,"C",IF(RANK($A1,$A$1:$A$100)/COUNTA($A$1:$A$100)<=0.8,"B","A"))))

If we assume these 100 people are relative to each other, wouldn't we instead take the top 20% to be A, next 20% to be B, and so on and so forth?
Assuming your handicaps (from 0 being the best to 10 being the worst) were in column A, here is your formula.

 

[KevCarter]

Re: Golf Handicps

Neon,

That solved the same question I've always had about a formula for flights. I've been handling the problem manually. I also found your formula easy to modify to get groups of 4-3-2. Wonderful job. Thank you very much for sharing!!!

Kevin

 

[Richard2542]

Re: Golf Handicps

Your assumption is correct - brilliant...I will try your formula - thanks so much; I'll let you know

 

[KevCarter]

Re: Golf Handicps

Richard,

I had some fun with this formula, and combined it with some things I learned from Mr. Excel and Mike Girvin. I have shared it in my drop box in case you are interested. The sheet has a subset of my Ladies League Members that would typically show up on a Tuesday Night. I can't wait to use this for my leagues. I now need to come up with a creative way to handle the stragglers that don't fit the numbers. Shouldn't be difficult. Please let me know what you think!

Thanks again NeonRedSharpie !!!

https://www.dropbox.com/s/ugfjsxrmjzmm8wt/Tournament Helper Flight Formulas.xlsx?dl=0

Kevin

 

[Richard2542]

Re: Golf Handicps

Kevin...not sure if my reply made it through. Your solution looks really great - I will need to spend some time reviewing it - thank you so much. I'll let you know how i make out.

 

[KevCarter]

Re: Golf Handicps

Cheers Richard. All you do is enter names and handicaps and Neon’s concepts do all the heavy lifting!

Kevin

 

[Richard2542]

Re: Golf Handicps

Kevin - Thanks again

 

[KevCarter]

Re: Golf Handicps

You bet. I forgot to mention, you can change the names of the flights, and everything updates!

 

[KevCarter]

Re: Golf Handicps

Updated to make it easy to select the number of flights you want in the last INDIVIDUALS column.

https://www.dropbox.com/s/ugfjsxrmjzmm8wt/Tournament Helper Flight Formulas.xlsx?dl=0