I have what at first glance appears to be a trivial task, but I've found it to be a bear to figure out.
Given an arbitrary even number of participants between 2 and 32 (lets call that number "n"), generate a listing of all possible tournament rounds consisting of n/2 games. Each match should appear in an separate cell and each round should appear on a separate line.
For example, given 4 players, numbered 1 through 4, here is what it would generate:
(1,2), (3,4)
(1,3), (2,4)
(1,4), (2,3)
Here is a start to what it would look like for 6 players:
(1,2), (3,4), (5,6)
(1,2), (3,5), (4,6)
(1,2), (3,6), (4,5)
(1,3), (2,4), (5,6)
(1,3), (2,5), (4,6)
(1,3), (2,6), (4,5)
(1,4), [...]
Obviously, the higher the number of players, the more games in each round and the more rounds are possible.
I would like to figure out a way to do this without resorting to VBA if possible.
Advice is greatly appreciated!
Bookmarks