20 golfers over 3 days playing in foursomes

golfnut111

New Member
Joined
Apr 4, 2019
Messages
5
I'm trying to create a spreadsheet where I can 20 golfers playing over 3 days and none of the golfers play with each other twice. On each team will be two "A" players and two "B" players. I've figured out how to make the 1st day random but I can't figure out out to make days 2 & 3 where the players don't play with each other again. Please help! I've been trying for half a day to figure this out. Is there a program to do this?
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

golfnut111

New Member
Joined
Apr 4, 2019
Messages
5
Thanks Perpa. I did see that, but I still have problems when I was working with only 20 golfers.
 

FracinDean

Board Regular
Joined
Jul 11, 2011
Messages
107
I think I have an idea that may work for you. Go back to the "Common Social Golfer Problem" thread. Their is another link at the bottom of that thread. The other link takes you to a free tool that I think will do this for you very well - but there is a twist. Instead of putting in 4 as the number of golfers per team, use 2 golfers, and use 10 golfers instead of 20. Then you generate an A golfer schedule and a B golfer schedule, and then just put them together.
 
Last edited by a moderator:

golfnut1

New Member
Joined
Jan 14, 2006
Messages
9

ADVERTISEMENT

That is a good idea. I’ll give it a try. Thanks again.
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,267
Office Version
  1. 2013
Platform
  1. Windows
@golfnut1
The link provided does allow for 20 golfers over 3 events !
Simply click on the pairings generator button and it will take you to the build schedule where you can set it up for your field.
 

golfnut111

New Member
Joined
Apr 4, 2019
Messages
5

ADVERTISEMENT

I'm still having problems solving this. The problem is I have 10 better players in one group or the "A" players and 10 worse players in another group or "B" players. I want 2 A and 2 B players in each foursome, but I don't want anyone to play with the same players twice over the 3 days. Maybe there isn't a simple way to do this and I have to just fumble with the different names until I get something that works. Thanks for all you help though. I really appreciate it.
 

Perpa

Well-known Member
Joined
Dec 18, 2012
Messages
632
golfnut11,
See if this layout is any help...


Excel 2007 32 bit
A
B
C
D
E
F
G
H
I
J
1
Tee 1Tee 2Tee 3Tee 4Tee 5
2
Day 12A 4A 2B 4B1A 5A 1B 5B7A 8A 7B 8B3A 10A 3B 10B6A 9A 6B 9B
3
4
Day 22A 4A 7B 8B3A 10A 2B 4B 1A 5A 3B 10B6A 9A 1B 5B 7A 8A 6B 9B
5
6
Day 32A 4A 6B 9B1A 5A 7B 8B3A 10A 1B 5B 6A 9A 2B 4B7A 8A 3B 10B
7
8
9
10
20 Golfers - 4somes - 3 Days
11
A' Flight'B' Flight
12
1AAlan1BPeter
13
2AGeorge2BFrank
14
3AJim3BJeff
15
4APat4BSam
16
5ADave5BConrad
17
6ARay6BTerry
18
7AMiles7BBob
19
8ALarry8BTed
20
9ADuncan9BJerry
21
10AMurphy10BZiggy
Sheet: Sheet2




I used the golf program in the last post of the "Common Social Golfer Problem" thread mentioned previously.
I had 10 'A' players (1A, 2A, and etc) and 10 'B' players (2A, 2B, and etc.) in the following format.
Then I used the code below to replace the corresponding name for each player in each 4 some.
I hope this is helpful.
Perpa


Code:
Sub AddPlayerNames()
Dim myString1, myString2 As String
Dim rw As Long


For rw = 12 To 21
      
    myString1 = Cells(rw, "A")
    myString2 = Cells(rw, "B")
    Range("B2:J6").Replace What:=myString1, Replacement:=myString2, LookAt:=xlPart, _
            SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
            ReplaceFormat:=False
Next


For rw = 12 To 21
      
    myString1 = Cells(rw, "E")
    myString2 = Cells(rw, "F")
    Range("B2:J6").Replace What:=myString1, Replacement:=myString2, LookAt:=xlPart, _
            SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
            ReplaceFormat:=False
Next
End Sub
 
Last edited:

golfnut111

New Member
Joined
Apr 4, 2019
Messages
5
If I'm reading this correctly, 2A & 4A are playing together all 3 days. What I want is to each player to have 9 different partners over the 3 days. He wouldn't see the same partner over the 3 days. I keep trying, but I'm thinking there might not be a solution.
 

Perpa

Well-known Member
Joined
Dec 18, 2012
Messages
632
golfnut111,
This is about as close as I was able to get...the last 2 foursomes (in red font) have played other players more than once, but 13 out of 15 foursomes seem well mixed...
Perpa

Excel 2007 32 bit
L
M
N
O
P
Q
53
Tee1 Tee2 Tee 3 Tee 4 Tee 5
54
Day 11A 2A 1B 2B3A 4A 3B 4B5A 6A 5B 6B7A 8A 7B 8B9A 10A 9B 10B
55
Day 210A 1A 4B 8B2A 9A 3B 6B4A 8A 5B 7B3A 6A 10B 1B5A7A 2B 9B
56
Day 31A 9A 3B 7B6A 8A 2B 4B 2A 4A 5B 10B5A 10A 6B 8B 3A 7A 1B 9B
Sheet: Sheet1
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,109,146
Messages
5,527,079
Members
409,743
Latest member
sukuto20

This Week's Hot Topics

Top