# 20 golfers over 3 days playing in foursomes

#### golfnut111

##### New Member
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?

### 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
Thanks Perpa. I did see that, but I still have problems when I was working with only 20 golfers.

#### FracinDean

##### Board Regular
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

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

#### Michael M

##### Well-known Member
@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

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
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
17
6ARay6BTerry
18
7AMiles7BBob
19
8ALarry8BTed
20
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.
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
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
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:

Replies
1
Views
200
Replies
2
Views
281
Replies
4
Views
3K
Replies
38
Views
2K
Replies
2
Views
420