The creation of a round robin tournament is a common topic in a Google search of the subject, and there are a myriad of different levels and complexites demonstrated. I decided to make a calculation model that would make this easy to do.
Starting in cell AK2, the names of the teams in the tournament are listed. For every name entered, a consecutive number must also be entered, starting with 0 in cell AL2. See the following figure.
And, that’s all you have to do!
The process runs entirely on Excel formulas – no VBA is used.
The resulting tournament schedule is shown in the following figure (partial view).
The workbook is completely unprotected, so feel free to discover how to works. There are a number of interesting and complex formulas used in the design of this model, both on the worksheet, in conditional formatting and in defined name formulas.
It is difficult to visualize the entire tournament bracket at once. Perhaps I will leave that issue as an exercise for the user.
The file can be downloaded here.