This seems to me to be a fairly complex question in combinatorial math-- not so much an Excel problem. There's certainly no built in function that will produce all the possible combinations, as far as I know. There are such functions as COMBIN and PERMUT (see Help) that will help in determining the *number* of such combinations, but they don't *show* those combinations, and even with these, you would have to adapt them according to the rules of your game, which are not clear. Just based on what you pasted into your post (I didn't look at the attachment), it's unclear whether each of the 3 games in each match is independent from the other 2, whether 1 player plays one other player, and who is playing who at any given time; for instance in the following set-up:
P1 P2 P3 P4
W W L L
is it
P1 vs. P3 and P2 vs. P4
or is it
P1 vs. P4 and P2 vs. P3
(and that's just game 1 of match 1 of ?? possible matches)
If you really needed to see all combinations, you would probably need to post to a math forum, get some pseudocode, and then have someone help you adapt that code to VBA to do this in Excel. Just a thought.
Bookmarks