Team Paring without Duplicates

[Strugglin Exceller]

I'm new here. and I have a problem that I have not been able to get an answer to. I thought it was simple and maybe I was overcomplicating it. but appears to be harder than I thought. I searched this forum and couldn't find what I need. so I apologize if this was already answered.

My local golf course asked me to create a spreadsheet for Auto paring teams and creating a schedule.

My Criteria:

• I want to make a schedule that is automated that takes the number of teams and pairs them over the course of 16 weeks. No one would play the same team again until everyone has played each other once. I believe there would be 120 matches before a team would play an opponent they already played if there were also 16 teams. once everyone has played each other once. it would start over.
• I would like to be able to make the season a variable so it can be adjusted. A typical season is 16 weeks
• I would like to make the number of teams a variable so that I can adjust each year as the teams increase or decrease each year.

The following screenshot is a sample of the schedule. 1 vs 2 etc is team number.
View attachment 33953

This is the formula I used =CONCATENATE((LEFT(R4,2)+1)," vs ",IF((RIGHT(R4,2)+1)=17,2,((RIGHT(R4,2)+1)))) It worked until week 11 until I ran into problems. I need to make 16 weeks

I'm assuming VBA may be easier. but I don't understand much of VBA.

Any help would be appreciated.

 

[diddi]

hi and welcome to MrExcel. is it possible to link your workbook so i can see what you have. you can use dropbox for that. i tend to go more for VBA solutions but i would still be interested to at least see if it is a simple error you have

 

[AhoyNC]

See attached link. Not Excel but may work for you.

Free round robin tournament schedule / pairings generator – GolfSoftware.com

Use our free round robin tournament generator to create your single round robin, double round robin or play with all schedule for your tournaments and leagues.

golfsoftware.com

 

[Strugglin Exceller]

hi and welcome to MrExcel. is it possible to link your workbook so i can see what you have. you can use dropbox for that. i tend to go more for VBA solutions but i would still be interested to at least see if it is a simple error you have

Thank you Diddi. Yes I can share the sheet to what I have. I can use dropbox.

 

[Fluff]

When you put the file on dropbox, mark for sharing & then post the link you are given to the thread.

 

[Strugglin Exceller]

Here is my file. It's very rough, Scratch League Schedule