How to create a list of all possible combinations

[smcrae]

Hi All

I need to find a way to list all possible combinations/permutations on excel. I have a list of 8 games of soccer each with a possible outcome of win, draw or win. I need to be able to show every combination for the 8 different results (not including 2 results from the same game). 8 different matches with 3 possible outcomes each match should mean there are 336 different combinations that could occur. I need to be able to show this in a list format. This is my data set and the template I would like to follow, with an outcome per combination looking like it does in the RHS table. What would the formula look like that I could drag down the cells to create each different combination.

I am on Excel for Mac 2011.

Thanks in advance! Will add reputation to anyone who can help me

 

[smcrae]

 

[diddi]

i am thinking there are 3^8 combinations here. or am i not seeing the problem correctly