Creating a 10 team fixture list where six of the teams share three grounds.

Secone

New Member
Joined
Feb 4, 2025
Messages
2
Office Version
  1. 2019
Platform
  1. Windows
I want to create a fixture list for 10 teams.
They play each other twice. Once home and once away.
The issue is: 6 of the teams share 3 grounds.
1) Ground 1 = BG and PN
2) Ground 2 = HO and RO
3) Ground 3 = GR and NH
4) Ground 4 = GU
5) Ground 5 = FU
6) Ground 6 = LO
7) Ground 7 = CH

Example


WEEKMatch 1Match 2Match 3Match 4Match 5
HOMEAWAYHOMEAWAYHOMEAWAYHOMEAWAYHOMEAWAY
1BGGRLOPNHO GU FU RO NHCH
2GUBGPNFUCHHOROLOGRNH

TEAMS
BG
PN
HO
RO
GR
NH
GU
FU
LO
CH


All teams play on the same night.
Each team must play their home fixtures at their respective home ground.
Ensure no double-booking of shared grounds in the same week.
So there are 5 matches per week.
Teams also only play once a week.
There is a total of 90 matches.
I can't get XL2BB to open in protected mode.
Thank you in advance for your help
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
FIXTURES 2025 TEMPLATE.xlsx
CDEFGHIJKLMN
4WEEKMatch 1Match 2Match 3Match 4Match 5TEAMS
5HOMEAWAYHOMEAWAYHOMEAWAYHOMEAWAYHOMEAWAY
61BGGRLOPNHO GU FU RO NHCHBG
72GUBGPNFUCHHOROLOGRNHPN
83HO
94RO
105GR
116NH
127GU
138FU
149LO
1510CH
1611
1712
1813
1914
2015
2116
2217
2318
Fixtures


Hopefully that's the template without any formatting/formulas
 
Upvote 0

Forum statistics

Threads
1,226,264
Messages
6,189,928
Members
453,582
Latest member
Browny2821

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top