Help with making excel sheet for all possible outcomes.....

[dymaster]

Hi Guys/Gals

I am trying to make a excel sheet to generate all possible outcomes of matches between 2 teams, but with lets say 10 games.

t1 vs t2
t3 vs t4
t5 vs t6
t7 vs t8
t9 vs t10
t11 vs t12
t13 vs t14
t15 vs t16
t17 vs t18
t19 vs t20

I want to see all win out comes. example all teams on the left win (1 outcome). All teams on right side win (another outcome). t1 vs t2 = t1 wins and all other matches the right side wins(another outcome). t1 wins t3 wins on left and the rest on right wins.(another outcome) Hopefully I explained what I needed clearly, hope there is someone out there that can help.

[newdoverman]

This is a multi step process the way I did it.
1. Create a matrix with all the values T1, T2 etc as column headers and Row IDs. Like this only with all the values and in B2 enter this formula and fill across and down:

Please Login or Register  to view this content.

The result will be like this only with all the values filled in.

	A	B	C	D	E	F
1		T1	T2	T3	T4	T5
2	T1		T2 T1	T3 T1	T4 T1	T5 T1
3	T2	T1 T2		T3 T2	T4 T2	T5 T2
4	T3	T1 T3	T2 T3		T4 T3	T5 T3
5	T4	T1 T4	T2 T4	T3 T4		T5 T4
6	T5	T1 T5	T2 T5	T3 T5	T4 T5

2. Enter this formula in W1 and fill down to extract all the values in the matrix into one column

Please Login or Register  to view this content.

3. This formula entered in X2 and filled down will extract all the unique values eliminating spaces.

Please Login or Register  to view this content.

Enter with Ctrl + Shift + Enter