Combination algorithm for this condition

[sleepwalker49]

Hi,
I have excel vba problem,

10 teams,

One times do each team play each other, 45 matches.

Week 1
Place A - 5 teams of 10
Place B - other 5 teams of 10
Week 2
Place C - 5 teams of 10
Place D - other 5 teams of 10
Week 3
Place E - 5 teams of 10
Place F - other 5 teams of 10

I need a combination algorithm for this condition
Thanks in advance

[MrShorty]

You have not described what kind of algorithm you want to use. If it helps, here's an example from this forum (https://www.excelforum.com/excel-for...scheduler.html ) that claims to put together a round robin tournament for up to 20 teams. If a round robin is suitable for what you want to do, you might look at this to see how they have done it. Even if you want a different pairing algorithm, it should be instructive to see how a round robin is programmed in Excel, and perhaps you can adapt that to you desired pairing algorithm.

[sleepwalker49]

Thanks, I'll look