How to Create a Round Robin Schedule in Excel

To build a round-robin schedule in Excel, list your teams in one column, keep the first team fixed, and rotate the rest one position each round — this is the circle method, and it guarantees every team plays every other exactly once in n − 1 rounds.
Below is the manual layout, the formula that does the rotating for you, and the point at which a spreadsheet stops being the right tool.
