Multiple Team Game Tournament Schedule (Excel Help)

[DannyDresdan]

I'm trying to run a laser tag tournament. In this tournament, multiple teams play one another in the same game. Therefore, the tradition excel sports scheduling formats that are available (i.e. – “1v1”) aren't that useful to me. In a perfect world, here's what I want to accomplish:

1) Have the teams play each other a fair amount of times to where thetop teams (“Team 1” – “Team 5”) and the middle teams (“Team 6” – “Team 10”). I know it won’t be perfect but I, at least, don’t want each team to play each other more than twice. <o></o>
2) Each team play 6 games each.<o></o>
Here is my schedule:<o></o>
[TABLE="class: MsoNormalTable, width: 4"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 320, bgcolor: transparent, colspan: 5"]

Tournament Schedule<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 320, bgcolor: transparent, colspan: 5"]

Pack Sets<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"]

Red<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Blue<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Green<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Yellow<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Purple<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 1<o></o>​

[/TD]
[TD="width: 64"]

Team 1<o></o>​

[/TD]
[TD="width: 64"]

Team 7<o></o>​

[/TD]
[TD="width: 64"]

Team 15<o></o>​

[/TD]
[TD="width: 64"]

Team 8<o></o>​

[/TD]
[TD="width: 64"]

Team 9<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 2<o></o>​

[/TD]
[TD="width: 64"]

Team 11<o></o>​

[/TD]
[TD="width: 64"]

Team 2<o></o>​

[/TD]
[TD="width: 64"]

Team 10<o></o>​

[/TD]
[TD="width: 64"]

Team 4<o></o>​

[/TD]
[TD="width: 64"]

Team 14<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 3<o></o>​

[/TD]
[TD="width: 64"]

Team 3<o></o>​

[/TD]
[TD="width: 64"]

Team 5<o></o>​

[/TD]
[TD="width: 64"]

Team 6<o></o>​

[/TD]
[TD="width: 64"]

Team 13<o></o>​

[/TD]
[TD="width: 64"]

Team 12<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 4<o></o>​

[/TD]
[TD="width: 64"]

Team 12<o></o>​

[/TD]
[TD="width: 64"]

Team 1<o></o>​

[/TD]
[TD="width: 64"]

Team 2<o></o>​

[/TD]
[TD="width: 64"]

Team 14<o></o>​

[/TD]
[TD="width: 64"]

Team 13<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 5<o></o>​

[/TD]
[TD="width: 64"]

Team 3<o></o>​

[/TD]
[TD="width: 64"]

Team 6<o></o>​

[/TD]
[TD="width: 64"]

Team 11<o></o>​

[/TD]
[TD="width: 64"]

Team 10<o></o>​

[/TD]
[TD="width: 64"]

Team 8<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 6<o></o>​

[/TD]
[TD="width: 64"]

Team 4<o></o>​

[/TD]
[TD="width: 64"]

Team 9<o></o>​

[/TD]
[TD="width: 64"]

Team 7<o></o>​

[/TD]
[TD="width: 64"]

Team 5<o></o>​

[/TD]
[TD="width: 64"]

Team 15<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 7<o></o>​

[/TD]
[TD="width: 64"]

Team 9<o></o>​

[/TD]
[TD="width: 64"]

Team 10<o></o>​

[/TD]
[TD="width: 64"]

Team 1<o></o>​

[/TD]
[TD="width: 64"]

Team 6<o></o>​

[/TD]
[TD="width: 64"]

Team 11<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 8<o></o>​

[/TD]
[TD="width: 64"]

Team 8<o></o>​

[/TD]
[TD="width: 64"]

Team 15<o></o>​

[/TD]
[TD="width: 64"]

Team 14<o></o>​

[/TD]
[TD="width: 64"]

Team 2<o></o>​

[/TD]
[TD="width: 64"]

Team 3<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 9<o></o>​

[/TD]
[TD="width: 64"]

Team 5<o></o>​

[/TD]
[TD="width: 64"]

Team 13<o></o>​

[/TD]
[TD="width: 64"]

Team 4<o></o>​

[/TD]
[TD="width: 64"]

Team 12<o></o>​

[/TD]
[TD="width: 64"]

Team 7<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 10<o></o>​

[/TD]
[TD="width: 64"]

Team 10<o></o>​

[/TD]
[TD="width: 64"]

Team 3<o></o>​

[/TD]
[TD="width: 64"]

Team 14<o></o>​

[/TD]
[TD="width: 64"]

Team 1<o></o>​

[/TD]
[TD="width: 64"]

Team 11<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 11<o></o>​

[/TD]
[TD="width: 64"]

Team 15<o></o>​

[/TD]
[TD="width: 64"]

Team 4<o></o>​

[/TD]
[TD="width: 64"]

Team 5<o></o>​

[/TD]
[TD="width: 64"]

Team 13<o></o>​

[/TD]
[TD="width: 64"]

Team 2<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 12<o></o>​

[/TD]
[TD="width: 64"]

Team 7<o></o>​

[/TD]
[TD="width: 64"]

Team 8<o></o>​

[/TD]
[TD="width: 64"]

Team 12<o></o>​

[/TD]
[TD="width: 64"]

Team 9<o></o>​

[/TD]
[TD="width: 64"]

Team 6<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 13<o></o>​

[/TD]
[TD="width: 64"]

Team 12<o></o>​

[/TD]
[TD="width: 64"]

Team 4<o></o>​

[/TD]
[TD="width: 64"]

Team 13<o></o>​

[/TD]
[TD="width: 64"]

Team 11<o></o>​

[/TD]
[TD="width: 64"]

Team 1<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 14<o></o>​

[/TD]
[TD="width: 64"]

Team 2<o></o>​

[/TD]
[TD="width: 64"]

Team 6<o></o>​

[/TD]
[TD="width: 64"]

Team 8<o></o>​

[/TD]
[TD="width: 64"]

Team 9<o></o>​

[/TD]
[TD="width: 64"]

Team 10<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 15<o></o>​

[/TD]
[TD="width: 64"]

Team 14<o></o>​

[/TD]
[TD="width: 64"]

Team 15<o></o>​

[/TD]
[TD="width: 64"]

Team 7<o></o>​

[/TD]
[TD="width: 64"]

Team 3<o></o>​

[/TD]
[TD="width: 64"]

Team 5<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 16<o></o>​

[/TD]
[TD="width: 64"]

Team 6<o></o>​

[/TD]
[TD="width: 64"]

Team 14<o></o>​

[/TD]
[TD="width: 64"]

Team 1<o></o>​

[/TD]
[TD="width: 64"]

Team 10<o></o>​

[/TD]
[TD="width: 64"]

Team 5<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 17<o></o>​

[/TD]
[TD="width: 64"]

Team 13<o></o>​

[/TD]
[TD="width: 64"]

Team 11<o></o>​

[/TD]
[TD="width: 64"]

Team 3<o></o>​

[/TD]
[TD="width: 64"]

Team 15<o></o>​

[/TD]
[TD="width: 64"]

Team 2<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 18<o></o>​

[/TD]
[TD="width: 64"]

Team 8<o></o>​

[/TD]
[TD="width: 64"]

Team 12<o></o>​

[/TD]
[TD="width: 64"]

Team 9<o></o>​

[/TD]
[TD="width: 64"]

Team 7<o></o>​

[/TD]
[TD="width: 64"]

Team 4<o></o>​

[/TD]
[/TR]
</tbody>[/TABLE]
<o></o>
<o></o>
I, then, want to tally how many times each team plays each other. I use the following base model to assist:<o></o>
<o></o>
[TABLE="class: MsoNormalTable, width: 768"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Team 1<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Team 2<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Team 3<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Team 4<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Team 5<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Team 6<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Team 7<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Team 8<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Team 9<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Team 10<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Team 11<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Team 12<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Team 13<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Team 14<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Team 15<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Team 1<o></o>​

[/TD]
[TD="width: 64"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Team 2<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Team 3<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Team 4<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Team 5<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Team 6<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Team 7<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Team 8<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Team 9<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Team 10<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Team 11<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Team 12<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Team 13<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Team 14<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Team 15<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64"]

<o></o>​

[/TD]
[/TR]
</tbody>[/TABLE]
<o></o>
My initial solution to avoid having to manually count everything (thereby increasing the chance of human error) was to use a COUNTIFS formula. Here is an example of that formula:<o></o>
<o></o>
=COUNTIFS(B4:F4,"Team 1",B4:F4,"Team 7")<o></o>
<o></o>
I want this formula to read the 5 teams playing in Round 1. Then I want it to read “Team 1” and then “Team 7” and count it as 1. However, when I plug this formula in, I get 0 instead. Why? This result doesn’t make sense to me at all. <o></o>

 

[shg]

Here's a round-robin for 15 teams; team 16 is a bye. Each team plays each other team once.

[Table="width:, class:grid"][tr][td] [/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][td]

D​

[/td][td]

E​

[/td][td]

F​

[/td][td]

G​

[/td][td]

H​

[/td][td]

I​

[/td][td]

J​

[/td][td]

K​

[/td][td]

L​

[/td][td]

M​

[/td][td]

N​

[/td][td]

O​

[/td][td]

P​

[/td][td]

Q​

[/td][/tr]
[tr][td]

3​

[/td][td]

Round​

[/td][td]Game 1[/td][td][/td][td]Game 2[/td][td][/td][td]Game 3[/td][td][/td][td]Game 4[/td][td][/td][td]Game 5[/td][td][/td][td]Game 6[/td][td][/td][td]Game 7[/td][td][/td][td]Game 8[/td][td][/td][/tr]

[tr][td]

4​

[/td][td]

1​

[/td][td]

1​

[/td][td]

16​

[/td][td]

2​

[/td][td]

15​

[/td][td]

3​

[/td][td]

14​

[/td][td]

4​

[/td][td]

13​

[/td][td]

5​

[/td][td]

12​

[/td][td]

6​

[/td][td]

11​

[/td][td]

7​

[/td][td]

10​

[/td][td]

8​

[/td][td]

9​

[/td][/tr]

[tr][td]

5​

[/td][td]

2​

[/td][td]

1​

[/td][td]

15​

[/td][td]

16​

[/td][td]

14​

[/td][td]

2​

[/td][td]

13​

[/td][td]

3​

[/td][td]

12​

[/td][td]

4​

[/td][td]

11​

[/td][td]

5​

[/td][td]

10​

[/td][td]

6​

[/td][td]

9​

[/td][td]

7​

[/td][td]

8​

[/td][/tr]

[tr][td]

6​

[/td][td]

3​

[/td][td]

1​

[/td][td]

14​

[/td][td]

15​

[/td][td]

13​

[/td][td]

16​

[/td][td]

12​

[/td][td]

2​

[/td][td]

11​

[/td][td]

3​

[/td][td]

10​

[/td][td]

4​

[/td][td]

9​

[/td][td]

5​

[/td][td]

8​

[/td][td]

6​

[/td][td]

7​

[/td][/tr]

[tr][td]

7​

[/td][td]

4​

[/td][td]

1​

[/td][td]

13​

[/td][td]

14​

[/td][td]

12​

[/td][td]

15​

[/td][td]

11​

[/td][td]

16​

[/td][td]

10​

[/td][td]

2​

[/td][td]

9​

[/td][td]

3​

[/td][td]

8​

[/td][td]

4​

[/td][td]

7​

[/td][td]

5​

[/td][td]

6​

[/td][/tr]

[tr][td]

8​

[/td][td]

5​

[/td][td]

1​

[/td][td]

12​

[/td][td]

13​

[/td][td]

11​

[/td][td]

14​

[/td][td]

10​

[/td][td]

15​

[/td][td]

9​

[/td][td]

16​

[/td][td]

8​

[/td][td]

2​

[/td][td]

7​

[/td][td]

3​

[/td][td]

6​

[/td][td]

4​

[/td][td]

5​

[/td][/tr]

[tr][td]

9​

[/td][td]

6​

[/td][td]

1​

[/td][td]

11​

[/td][td]

12​

[/td][td]

10​

[/td][td]

13​

[/td][td]

9​

[/td][td]

14​

[/td][td]

8​

[/td][td]

15​

[/td][td]

7​

[/td][td]

16​

[/td][td]

6​

[/td][td]

2​

[/td][td]

5​

[/td][td]

3​

[/td][td]

4​

[/td][/tr]

[tr][td]

10​

[/td][td]

7​

[/td][td]

1​

[/td][td]

10​

[/td][td]

11​

[/td][td]

9​

[/td][td]

12​

[/td][td]

8​

[/td][td]

13​

[/td][td]

7​

[/td][td]

14​

[/td][td]

6​

[/td][td]

15​

[/td][td]

5​

[/td][td]

16​

[/td][td]

4​

[/td][td]

2​

[/td][td]

3​

[/td][/tr]

[tr][td]

11​

[/td][td]

8​

[/td][td]

1​

[/td][td]

9​

[/td][td]

10​

[/td][td]

8​

[/td][td]

11​

[/td][td]

7​

[/td][td]

12​

[/td][td]

6​

[/td][td]

13​

[/td][td]

5​

[/td][td]

14​

[/td][td]

4​

[/td][td]

15​

[/td][td]

3​

[/td][td]

16​

[/td][td]

2​

[/td][/tr]

[tr][td]

12​

[/td][td]

9​

[/td][td]

1​

[/td][td]

8​

[/td][td]

9​

[/td][td]

7​

[/td][td]

10​

[/td][td]

6​

[/td][td]

11​

[/td][td]

5​

[/td][td]

12​

[/td][td]

4​

[/td][td]

13​

[/td][td]

3​

[/td][td]

14​

[/td][td]

2​

[/td][td]

15​

[/td][td]

16​

[/td][/tr]

[tr][td]

13​

[/td][td]

10​

[/td][td]

1​

[/td][td]

7​

[/td][td]

8​

[/td][td]

6​

[/td][td]

9​

[/td][td]

5​

[/td][td]

10​

[/td][td]

4​

[/td][td]

11​

[/td][td]

3​

[/td][td]

12​

[/td][td]

2​

[/td][td]

13​

[/td][td]

16​

[/td][td]

14​

[/td][td]

15​

[/td][/tr]

[tr][td]

14​

[/td][td]

11​

[/td][td]

1​

[/td][td]

6​

[/td][td]

7​

[/td][td]

5​

[/td][td]

8​

[/td][td]

4​

[/td][td]

9​

[/td][td]

3​

[/td][td]

10​

[/td][td]

2​

[/td][td]

11​

[/td][td]

16​

[/td][td]

12​

[/td][td]

15​

[/td][td]

13​

[/td][td]

14​

[/td][/tr]

[tr][td]

15​

[/td][td]

12​

[/td][td]

1​

[/td][td]

5​

[/td][td]

6​

[/td][td]

4​

[/td][td]

7​

[/td][td]

3​

[/td][td]

8​

[/td][td]

2​

[/td][td]

9​

[/td][td]

16​

[/td][td]

10​

[/td][td]

15​

[/td][td]

11​

[/td][td]

14​

[/td][td]

12​

[/td][td]

13​

[/td][/tr]

[tr][td]

16​

[/td][td]

13​

[/td][td]

1​

[/td][td]

4​

[/td][td]

5​

[/td][td]

3​

[/td][td]

6​

[/td][td]

2​

[/td][td]

7​

[/td][td]

16​

[/td][td]

8​

[/td][td]

15​

[/td][td]

9​

[/td][td]

14​

[/td][td]

10​

[/td][td]

13​

[/td][td]

11​

[/td][td]

12​

[/td][/tr]

[tr][td]

17​

[/td][td]

14​

[/td][td]

1​

[/td][td]

3​

[/td][td]

4​

[/td][td]

2​

[/td][td]

5​

[/td][td]

16​

[/td][td]

6​

[/td][td]

15​

[/td][td]

7​

[/td][td]

14​

[/td][td]

8​

[/td][td]

13​

[/td][td]

9​

[/td][td]

12​

[/td][td]

10​

[/td][td]

11​

[/td][/tr]

[tr][td]

18​

[/td][td]

15​

[/td][td]

1​

[/td][td]

2​

[/td][td]

3​

[/td][td]

16​

[/td][td]

4​

[/td][td]

15​

[/td][td]

5​

[/td][td]

14​

[/td][td]

6​

[/td][td]

13​

[/td][td]

7​

[/td][td]

12​

[/td][td]

8​

[/td][td]

11​

[/td][td]

9​

[/td][td]

10​

[/td][/tr]
[/table]

This was copied from the workbook at https://app.box.com/s/z41sn0yrp5lo1cuozke3

 

[DannyDresdan]

SHG

I appreciate the help, but this solution doesn't answer my question or solve my problem. Perhaps I didn't explain this well. Let me try again:

In each round, 5 teams are playing each other simultaneously. So, therefore, the 1v1 model isn't helpful to me.

I'm convinced that the COUNTIFS function can help me but I'm unable to get this to work. Would you, or anybody, be able to help me with this?

 

[shg]

Ah.

There are 3003 combinations of 15 choose 5. You could list all of those combinations and calculate some criteria that measures how well it meets whatever criteria you want to apply (which I don't understand). Then sort by the goodness criteria.

 

[Marcelo Branco]

In your schedule there are teams playing more than twice against each other.

Assuming the games in B4:F21


[TABLE="class: grid"]
<TBODY>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[TD]

D​

[/TD]
[TD]

E​

[/TD]
[TD]

F​

[/TD]
[TD]

G​

[/TD]
[TD]

H​

[/TD]
[TD]

I​

[/TD]
[TD]

J​

[/TD]
[TD]

K​

[/TD]
[TD]

L​

[/TD]
[TD]

M​

[/TD]
[TD]

N​

[/TD]
[TD]

O​

[/TD]
[TD]

P​

[/TD]
[/TR]
[TR]
[TD]

24​

[/TD]
[TD][/TD]
[TD]

Team 1​

[/TD]
[TD]

Team 2​

[/TD]
[TD]

Team 3​

[/TD]
[TD]

Team 4​

[/TD]
[TD]

Team 5​

[/TD]
[TD]

Team 6​

[/TD]
[TD]

Team 7​

[/TD]
[TD]

Team 8​

[/TD]
[TD]

Team 9​

[/TD]
[TD]

Team 10​

[/TD]
[TD]

Team 11​

[/TD]
[TD]

Team 12​

[/TD]
[TD]

Team 13​

[/TD]
[TD]

Team 14​

[/TD]
[TD]

Team 15​

[/TD]
[/TR]
[TR]
[TD]

25​

[/TD]
[TD]

Team 1​

[/TD]
[TD]

0​

[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[TD]

2​

[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[TD]

2​

[/TD]
[TD]

3​

[/TD]
[TD]

3​

[/TD]
[TD]

2​

[/TD]
[TD]

2​

[/TD]
[TD]

3​

[/TD]
[TD]

1​

[/TD]
[/TR]
[TR]
[TD]

26​

[/TD]
[TD]

Team 2​

[/TD]
[TD]

1​

[/TD]
[TD]

0​

[/TD]
[TD]

2​

[/TD]
[TD]

2​

[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[TD]

0​

[/TD]
[TD]

2​

[/TD]
[TD]

1​

[/TD]
[TD]

2​

[/TD]
[TD]

2​

[/TD]
[TD]

1​

[/TD]
[TD]

3​

[/TD]
[TD]

3​

[/TD]
[TD]

3​

[/TD]
[/TR]
[TR]
[TD]

27​

[/TD]
[TD]

Team 3​

[/TD]
[TD]

1​

[/TD]
[TD]

2​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

2​

[/TD]
[TD]

2​

[/TD]
[TD]

1​

[/TD]
[TD]

2​

[/TD]
[TD]

0​

[/TD]
[TD]

2​

[/TD]
[TD]

3​

[/TD]
[TD]

1​

[/TD]
[TD]

2​

[/TD]
[TD]

3​

[/TD]
[TD]

3​

[/TD]
[/TR]
[TR]
[TD]

28​

[/TD]
[TD]

Team 4​

[/TD]
[TD]

1​

[/TD]
[TD]

2​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

3​

[/TD]
[TD]

0​

[/TD]
[TD]

3​

[/TD]
[TD]

1​

[/TD]
[TD]

2​

[/TD]
[TD]

1​

[/TD]
[TD]

2​

[/TD]
[TD]

3​

[/TD]
[TD]

3​

[/TD]
[TD]

1​

[/TD]
[TD]

2​

[/TD]
[/TR]
[TR]
[TD]

29​

[/TD]
[TD]

Team 5​

[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[TD]

2​

[/TD]
[TD]

3​

[/TD]
[TD]

0​

[/TD]
[TD]

2​

[/TD]
[TD]

3​

[/TD]
[TD]

0​

[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[TD]

0​

[/TD]
[TD]

2​

[/TD]
[TD]

3​

[/TD]
[TD]

2​

[/TD]
[TD]

3​

[/TD]
[/TR]
[TR]
[TD]

30​

[/TD]
[TD]

Team 6​

[/TD]
[TD]

2​

[/TD]
[TD]

1​

[/TD]
[TD]

2​

[/TD]
[TD]

0​

[/TD]
[TD]

2​

[/TD]
[TD]

0​

[/TD]
[TD]

1​

[/TD]
[TD]

3​

[/TD]
[TD]

3​

[/TD]
[TD]

4​

[/TD]
[TD]

2​

[/TD]
[TD]

2​

[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[TD]

0​

[/TD]
[/TR]
[TR]
[TD]

31​

[/TD]
[TD]

Team 7​

[/TD]
[TD]

1​

[/TD]
[TD]

0​

[/TD]
[TD]

1​

[/TD]
[TD]

3​

[/TD]
[TD]

3​

[/TD]
[TD]

1​

[/TD]
[TD]

0​

[/TD]
[TD]

3​

[/TD]
[TD]

4​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

3​

[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[TD]

3​

[/TD]
[/TR]
[TR]
[TD]

32​

[/TD]
[TD]

Team 8​

[/TD]
[TD]

1​

[/TD]
[TD]

2​

[/TD]
[TD]

2​

[/TD]
[TD]

1​

[/TD]
[TD]

0​

[/TD]
[TD]

3​

[/TD]
[TD]

3​

[/TD]
[TD]

0​

[/TD]
[TD]

4​

[/TD]
[TD]

2​

[/TD]
[TD]

1​

[/TD]
[TD]

2​

[/TD]
[TD]

0​

[/TD]
[TD]

1​

[/TD]
[TD]

2​

[/TD]
[/TR]
[TR]
[TD]

33​

[/TD]
[TD]

Team 9​

[/TD]
[TD]

2​

[/TD]
[TD]

1​

[/TD]
[TD]

0​

[/TD]
[TD]

2​

[/TD]
[TD]

1​

[/TD]
[TD]

3​

[/TD]
[TD]

4​

[/TD]
[TD]

4​

[/TD]
[TD]

0​

[/TD]
[TD]

2​

[/TD]
[TD]

1​

[/TD]
[TD]

2​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

2​

[/TD]
[/TR]
[TR]
[TD]

34​

[/TD]
[TD]

Team 10​

[/TD]
[TD]

3​

[/TD]
[TD]

2​

[/TD]
[TD]

2​

[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[TD]

4​

[/TD]
[TD]

0​

[/TD]
[TD]

2​

[/TD]
[TD]

2​

[/TD]
[TD]

0​

[/TD]
[TD]

4​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

3​

[/TD]
[TD]

0​

[/TD]
[/TR]
[TR]
[TD]

35​

[/TD]
[TD]

Team 11​

[/TD]
[TD]

3​

[/TD]
[TD]

2​

[/TD]
[TD]

3​

[/TD]
[TD]

2​

[/TD]
[TD]

0​

[/TD]
[TD]

2​

[/TD]
[TD]

0​

[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[TD]

4​

[/TD]
[TD]

0​

[/TD]
[TD]

1​

[/TD]
[TD]

2​

[/TD]
[TD]

2​

[/TD]
[TD]

1​

[/TD]
[/TR]
[TR]
[TD]

36​

[/TD]
[TD]

Team 12​

[/TD]
[TD]

2​

[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[TD]

3​

[/TD]
[TD]

2​

[/TD]
[TD]

2​

[/TD]
[TD]

3​

[/TD]
[TD]

2​

[/TD]
[TD]

2​

[/TD]
[TD]

0​

[/TD]
[TD]

1​

[/TD]
[TD]

0​

[/TD]
[TD]

4​

[/TD]
[TD]

1​

[/TD]
[TD]

0​

[/TD]
[/TR]
[TR]
[TD]

37​

[/TD]
[TD]

Team 13​

[/TD]
[TD]

2​

[/TD]
[TD]

3​

[/TD]
[TD]

2​

[/TD]
[TD]

3​

[/TD]
[TD]

3​

[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

2​

[/TD]
[TD]

4​

[/TD]
[TD]

0​

[/TD]
[TD]

1​

[/TD]
[TD]

2​

[/TD]
[/TR]
[TR]
[TD]

38​

[/TD]
[TD]

Team 14​

[/TD]
[TD]

3​

[/TD]
[TD]

3​

[/TD]
[TD]

3​

[/TD]
[TD]

1​

[/TD]
[TD]

2​

[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[TD]

0​

[/TD]
[TD]

3​

[/TD]
[TD]

2​

[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[TD]

0​

[/TD]
[TD]

2​

[/TD]
[/TR]
[TR]
[TD]

39​

[/TD]
[TD]

Team 15​

[/TD]
[TD]

1​

[/TD]
[TD]

3​

[/TD]
[TD]

3​

[/TD]
[TD]

2​

[/TD]
[TD]

3​

[/TD]
[TD]

0​

[/TD]
[TD]

3​

[/TD]
[TD]

2​

[/TD]
[TD]

2​

[/TD]
[TD]

0​

[/TD]
[TD]

1​

[/TD]
[TD]

0​

[/TD]
[TD]

2​

[/TD]
[TD]

2​

[/TD]
[TD]

0​

[/TD]
[/TR]
</TBODY>[/TABLE]


Formula in B25 copied across and down
=SUMPRODUCT(--(MMULT(--((($B$4:$F$21=$A25)+($B$4:$F$21=B$24))>0),ROW($A$1:$A$5)^0)>1))

M.

 

[DannyDresdan]

@ Marcelo Branco...This is EXACTLY what I was looking for! Haven't had an opportunity to reverse engineer it, looking forward to it though. This formula accomplished every need!

 

[Marcelo Branco]

@ Marcelo Branco...This is EXACTLY what I was looking for! Haven't had an opportunity to reverse engineer it, looking forward to it though. This formula accomplished every need!

To understand the formula try the tool Formulas > Evaluate formula

Note:
1. In a multiplication of matrices, the second matrix must have the number of rows equal to the number of columns of the first matrix.

2. The first matrix is produced comparing each value (team) in the range B4:F21 with the team in column A and with the team in row 24 of the same column.

3. The second matrix (a vector, i.e. a one dimension matrix) is generated by ROW(A1:A5)^0
ROW(A1:A5) produces a vertical vector
{1;2;3;4;5}
as any number powered 0 results in 1
{1;2;3;4;5}^0 results in a vector like {1;1;1;1;1}

4. Take a look at help file and see how the function MMULT works

5. SUMPRODUCT takes the array produced by MMULT and check, for each value, the condition >1, generating an array of logical values True or False. Each value of this array is coerced by -- (double unary operator) to, respectively, 1 or 0

6. At last, SUMPRODUCT sums the values of this array of 0s and 1s.


M.

 

[markmzz]

Another way:

Array formula - use Ctrl+Shift+Enter and not only Enter to enter the formula

=IF($A24=B$23,0,SUM(--(MMULT(($A24=$B$4:$F$21)+(B$23=$B$4:$F$21),TRANSPOSE(COLUMN($B$4:$F$4)^0))=2)))

Markmzz

 

[markmzz]

A small modification in my formula:

In B24 - use only Enter to enter the formula

=IF($A24=B$23,0,SUM(--(MMULT(($A24=$B$4:$F$21)+(B$23=$B$4:$F$21),{1;1;1;1;1})=2)))

Markmzz

 

[DannyDresdan]

I'm still having trouble reverse engineering this excel formula. I'm making a minor adjustment to account for 6 teams playing per game, instead of 5. This, not only, makes the schedule shorter but it also allows even scheduling in scenarios where I fall short of my 15 team goal (i.e. - 12 to 14 teams attending).
[TABLE="width: 448"]
<tbody>[TR]
[TD]
[/TD]
[TD]Red
[/TD]
[TD]Blue
[/TD]
[TD]Green
[/TD]
[TD]Yellow
[/TD]
[TD]Purple
[/TD]
[TD]White
[/TD]
[/TR]
[TR]
[TD]Round 1
[/TD]
[TD]Team 1
[/TD]
[TD]Team 13
[/TD]
[TD]Team 15
[/TD]
[TD]Team 8
[/TD]
[TD]Team 10
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 2
[/TD]
[TD]Team 3
[/TD]
[TD]Team 2
[/TD]
[TD]Team 7
[/TD]
[TD]Team 4
[/TD]
[TD]Team 6
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 3
[/TD]
[TD]Team 14
[/TD]
[TD]Team 5
[/TD]
[TD]Team 12
[/TD]
[TD]Team 11
[/TD]
[TD]Team 9
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 4
[/TD]
[TD]Team 13
[/TD]
[TD]Team 1
[/TD]
[TD]Team 2
[/TD]
[TD]Team 14
[/TD]
[TD]Team 12
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 5
[/TD]
[TD]Team 3
[/TD]
[TD]Team 6
[/TD]
[TD]Team 11
[/TD]
[TD]Team 10
[/TD]
[TD]Team 4
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 6
[/TD]
[TD]Team 15
[/TD]
[TD]Team 7
[/TD]
[TD]Team 9
[/TD]
[TD]Team 5
[/TD]
[TD]Team 8
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 7
[/TD]
[TD]Team 9
[/TD]
[TD]Team 10
[/TD]
[TD]Team 1
[/TD]
[TD]Team 6
[/TD]
[TD]Team 11
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 8
[/TD]
[TD]Team 8
[/TD]
[TD]Team 14
[/TD]
[TD]Team 15
[/TD]
[TD]Team 2
[/TD]
[TD]Team 3
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 9
[/TD]
[TD]Team 5
[/TD]
[TD]Team 13
[/TD]
[TD]Team 4
[/TD]
[TD]Team 12
[/TD]
[TD]Team 7
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 10
[/TD]
[TD]Team 4
[/TD]
[TD]Team 3
[/TD]
[TD]Team 10
[/TD]
[TD]Team 1
[/TD]
[TD]Team 5
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 11
[/TD]
[TD]Team 2
[/TD]
[TD]Team 11
[/TD]
[TD]Team 14
[/TD]
[TD]Team 13
[/TD]
[TD]Team 15
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 12
[/TD]
[TD]Team 7
[/TD]
[TD]Team 8
[/TD]
[TD]Team 6
[/TD]
[TD]Team 9
[/TD]
[TD]Team 12
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 13
[/TD]
[TD]Team 12
[/TD]
[TD]Team 4
[/TD]
[TD]Team 1
[/TD]
[TD]Team 11
[/TD]
[TD]Team 13
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 14
[/TD]
[TD]Team 2
[/TD]
[TD]Team 6
[/TD]
[TD]Team 8
[/TD]
[TD]Team 9
[/TD]
[TD]Team 10
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 15
[/TD]
[TD]Team 7
[/TD]
[TD]Team 15
[/TD]
[TD]Team 5
[/TD]
[TD]Team 3
[/TD]
[TD]Team 14
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 16
[/TD]
[TD]Team 6
[/TD]
[TD]Team 12
[/TD]
[TD]Team 4
[/TD]
[TD]Team 14
[/TD]
[TD]Team 5
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 17
[/TD]
[TD]Team 11
[/TD]
[TD]Team 9
[/TD]
[TD]Team 13
[/TD]
[TD]Team 15
[/TD]
[TD]Team 2
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 18
[/TD]
[TD]Team 10
[/TD]
[TD]Team 8
[/TD]
[TD]Team 3
[/TD]
[TD]Team 7
[/TD]
[TD]Team 1
[/TD]
[TD]???
[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 960"]
<tbody>[TR]
[TD]
[/TD]
[TD]Team 1
[/TD]
[TD]Team 2
[/TD]
[TD]Team 3
[/TD]
[TD]Team 4
[/TD]
[TD]Team 5
[/TD]
[TD]Team 6
[/TD]
[TD]Team 7
[/TD]
[TD]Team 8
[/TD]
[TD]Team 9
[/TD]
[TD]Team 10
[/TD]
[TD]Team 11
[/TD]
[TD]Team 12
[/TD]
[TD]Team 13
[/TD]
[TD]Team 14
[/TD]
[/TR]
[TR]
[TD]Team 1
[/TD]
[TD]0
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]4
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Team 2
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]Team 3
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]Team 4
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[TD]0
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Team 5
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]0
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]Team 6
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Team 7
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Team 8
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]0
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD]0
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Team 9
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Team 10
[/TD]
[TD]4
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[/TR]
[TR]
[TD]Team 11
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]Team 12
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]Team 13
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]Team 14
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[/TR]
</tbody>[/TABLE]

How can I adjust this graph to account for a change in total teams attending? Again, all attempts to reverse engineer individually have failed to get my desired result.