Need help creating a league schedule

[Wadyusayder]

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!!

 

[TCM1770]

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