Need to create a schedule for 10 teams. 1 game per week. 20 weeks in season. 2 divisions of 5. Want to play same division 3 times each then remaining 8 games against opposite division. HELP!!
I created a tracker for our card league. You need to start off with the random numbers (team 1vs team 2) why the odd number 5 does one team get a buy each week.. then you set up your roster and create a schedule from that data. I used vlookups and match but if you read my post I have an error somewhere or a fantom formula somewhere that is putting the results in the wrong week… hope this helps you get started
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.