Generate Combinations in Excel

Hi guys...Have another question today..

Player 1 Player 2 Player 3 Player 4
W W L L
W W L L
W W L L

This is inside my excel. I need some help to generate combinations based on this 3 rows..

Can i automatically generate all possible combinations in excel in this format given in my excel.

It must contain 6W and 6L in total. For each 4x3 combo...

Anyone care to help me out on this..

Anyone...

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.