Sort golfing foursomes by hanicaps with no repeating team members

[golfnut1]

We have a group of 24 golfers going on a golf trip for 3 days. I would like to create a spreadsheet where I can enter in the names of the golfers with their handicaps and with the push of a button have the spreadsheet create 6 teams where the top 6 handicapped (low number) golfers lead each team and the rest of the teams are filled in so the total handicaps for each team are close to equal.

Example: Golfer A =6, Golfer B = 8, Golfer C = 8, Golfer D = 10, equals a total of 32
Golfer E = 5, Golfer F = 7, Golfer G = 12, Golfer H = 8 equals a total of 32
Golfer I = 5, Golfer J = 10, Golfer K = 10, Golfer L = 7 equals a total of 32
Golfer M = 7, Golfer N = 7, Golfer O = 8, Golfer P = 11 equals a total of 33 and this continues for 24 golfers
Golfer A would not play with B, C, or D again on the 2nd or 3rd day.
Golfer E would not play with F, G, or H again on the 2nd or 3rd day..
Golfer I would not play with J, K, or L again on the 2nd or 3rd day.
Golfer M would not play with N, O, or P again on the 2nd or 3rd day and this would continue with all 24 golfers. The totals for each foursome would still total close to the same so each team is of equal talent.

Another option is to enter the names of the golfers with their handicaps entered so there is a list of 12 "A" golfers and 12 "B" golfers. With the push of a button, 6 teams are created with 2 "A" golfers are on each team and 2 "B" golfers are on each team with the total handicaps about the same for each team.
Another requirement I would like is to make sure no two golfers are golfing together more than 1 day. For example, if Joe is golfing with Bob on day one, he won't be golfing with him again on day 2 or day 3.
Is this possible? Can it be modified for more foursomes?
Thanks for any help.

 

[igold]

Hi golfnut1,

I think that with only 24 golfers, you could have given us the 24 actual handicaps that you want us to work with, as opposed the examples as posted. It does not matter if it is Golfer A - Golfer X, as long the handicaps are accurate.

I don't know that I have a solution, but I would like to able to manipulate the real numbers.

igold

 

[golfnut1]

Hi Igold,

Thanks for the reply. I have to get contact someone for some more information and I will get back to you soon.

Thanks,
Golfnut1

 

[golfnut1]

Hey Igold,
Here are the handicaps:
Bob R. 10 Greg A. 12 Bob E. 14 Troy M. 18 Mark L. 20 Scott L. 24
Shawn L. 10 Lonny R. 12 John H. 15 Paul B. 18 Rocky R. 20 Matt L. 24
Jim M. 10 Neal H. 12 **** K. 16 Denny G. 18 Fred N. 20 Mike A. 24
Lonny M. 11 Randy L. 13 Sean U. 16 Paul G. 18 Harry G. 20 Jeff S. 24

Thanks,
Golfnut1

 

[golfnut1]

That didn't look so good when sent, so here it is again.
Bob R. 10
Shawn L. 10
Jim M. 10
Lonny M. 10
Greg A. 12
Lonny R. 12
Neal H. 12
Randy L. 13
Bob E. 14
John H. 15
**** K. 16
Sean U. 16
Troy M. 18
Paul B. 18
Denny G. 18
Paul G. 18
Mark L. 20
Rocky R. 20
Fred N. 20
Harry G. 20
Scott L. 24
Matt L. 24
Mike A. 24
Jeff S. 24

 

[golfnut1]

Maybe I should put is Richard K. instead of **** K.