Hi, I am completely new to the forum and am not great at excel. After changing the amount of regular season weeks in my fantasy football league, the entire remaining schedule has been changed with lots of repeat matchups. I called ESPN to try to fix it but they couldn't. I have the ability to edit any of the remaining matchups myself and would like to randomly create this schedule while keeping the existing schedule (5 weeks worth) intact and making it so each team plays another team exactly one time. I have been trying to create a formula to do this but I am nowhere near skilled enough. Is this even possible to do??? Can anyone help?
Here is the table with the matchups that have already occurred. For example, Team A played Team C in week 1. If I need to provide any other information please ask.
<tbody>
</tbody>
Thanks!!!!!!!
Here is the table with the matchups that have already occurred. For example, Team A played Team C in week 1. If I need to provide any other information please ask.
A | B | C | D | E | F | G | H | I | J | K | L | M | N | |
1 | C | D | A | B | L | G | F | M | J | I | N | E | H | K |
2 | N | M | L | J | G | H | E | F | K | D | I | C | B | A |
3 | I | J | G | K | H | M | C | E | A | B | D | N | F | L |
4 | D | K | H | A | M | J | L | C | N | F | B | G | E | I |
5 | B | A | M | N | F | E | I | L | G | K | J | H | C | D |
6 | ||||||||||||||
7 | ||||||||||||||
8 | ||||||||||||||
9 | ||||||||||||||
10 | ||||||||||||||
11 | ||||||||||||||
12 | ||||||||||||||
13 | ||||||||||||||
14 |
<tbody>
</tbody>
Thanks!!!!!!!