20 players 2 teams 3 rounds

[leethepee]

Can someone give me some help on this?
Set up so no players play in same group more than once.
foursomes with 2 players from each team.

 

[Andrew Fergus]

Hello and welcome to MrExcel

This is more of a logic issue than an Excel issue. Out of curiosity, is this for bridge?

I think I have a solution, if you can follow the layout below. This is assuming a team of 2 versus another team of 2, with 3 rounds. No player can play with or against the same player in the 3 rounds. Players are numbered 1 to 20. I have assumed games are played on tables.

		Team 1			Team 2
Round	Table	Player 1	Player 2	vs	Player 1	Player 2
1​	1​	1	2		11	12
	2​	3	4		13	14
	3​	5	6		15	16
	4​	7	8		17	18
	5​	9	10		19	20
Round	Table	Player 1	Player 2		Player 1	Player 2
2​	1​	1	3		17	16
	2​	5	2		19	18
	3​	7	4		11	20
	4​	9	6		13	12
	5​	10	8		15	14
Round	Table	Player 1	Player 2		Player 1	Player 2
3​	1​	1	5		13	20
	2​	7	3		15	19
	3​	9	2		17	14
	4​	8	4		12	16
	5​	10	6		11	18
Logic		hold player 1			P1 down 2	P2 up 2
		rotate others clockwise
		except :			except :
		swap 8 & 10 in R3 to fix			swap 12 & 19 in R3 to fix

 

[leethepee]

Thank you. This is for a Golf Tournament. I will substitute Tee for Table. You don't know how grateful I am. I know it is a math problem. But You guys on Mr. Excel are the best.
Thanks again. This is perfect.

 

[Andrew Fergus]

You're welcome and I'm happy to help.

With a round robin system to get one team playing every other team you line them up like I did for Team 1, then you hold player 1 while you rotate all the other players clockwise for each subsequent round. This works perfectly for team 1. But we can't use the same method for team in this versus situation given it would result in opponents meeting more than once, so I needed to use a slightly different method to shuffle the players in Team 2. I did this by moving players up or down 2 rows in each column for Team 2. It mostly worked but I had to swap 2 pairs in the final round to ensure there were no 're-matches' so to speak.

Good luck with your tournament!