List all possible outcomes combinations for 8 soccer matches.

[Efuentes26]

I know the number of possible outcomes is 512.

An example will be as follows.
List all possible outcomes for 3 matches.
That will be 27 possible outcomes.
I would like results for my request of 8 matches to be displayed as follows.


HHH
HHD
HHA
HDH
HDD
HDA
HAH
HAD
HAA
DHH
DHD
DHA
DDH
DDD
DDA
DAH
DAD
DAA
AHH
AHD
AHA
ADH
ADD
ADA
AAH
AAD
AAA


Where:
H=HOME
D=DRAW
A=AWAY


Is there a way i can have the possible outcomes listed as above for the outcomes of 8 football matches?
Please help me out, i have to confess i am not conversant with Excel but would really like to learn as much as i can from you all.


Thank you so very much!!!!

 

[kinzu]

In A1, =MID("HDA", MOD(INT(3 * (ROWS($H$1:Me) - 1) / 3 ^ COLUMNS($H$1:Me)), 3) + 1, 1) Copy to H1 then down 6561 rows.

Great and on point response shg however i need your help getting a List of all possible outcomes combinations (correct scores) for 3 soccer matches. I have a variant to the match prediction question. I want a 3 match exact score prediction excel table or formula for all possible results such that when both matches are plaid and the number of goals is 3 or less, one of the entries will be the correct scores for both matches Below are a list of all possible results for one match; I need all possible combinations for A,B,C,D,E,F,G,H,I and J for the 3 matches A = 0 - 0 B = 0 - 1 C = 1 - 0 D = 1 - 1 E = 1 - 2 F = 2 - 1 G = 2 - 0 H = 0 - 2 I = 3 - 0 J = 0 - 3 Thanks

 

[Chika]

Please help me out in the sample spaces for 8 football matches.

 

[RichSteve]

I need all the outcomes displayed

 

[MOINDI]

Copied the formula"=MID("HDA", MOD(INT(3 * (ROWS(H1:A1) - 1) / 3 ^ COLUMNS(H1:A1)), 3) + 1, 1)

" to A1, dragged cell A1 TO H1 then down 6561 rows but it did not work.

 

[West Man]

Try it with $H$1:A1 It should work then

 

[Odurok]

Thank you for that, and sorry for the confusion -- it's a standard name in my template workbook.

	A​	B​	C​	D​	E​	F​	G​	H​
1​	H	H	H	H	H	H	H	H
2​	H	H	H	H	H	H	H	D
3​	H	H	H	H	H	H	H	A
4​	H	H	H	H	H	H	D	H
5​	H	H	H	H	H	H	D	D
6​	H	H	H	H	H	H	D	A
7​	H	H	H	H	H	H	A	H
8​	H	H	H	H	H	H	A	D
9​	H	H	H	H	H	H	A	A
10​	…	…	…	…	…	…	…	…

Can you please explain it will I’m using the excel on my Iphone

 

[Odurok]

do you mean down 6561 columns ?

Copied the formula"=MID("HDA", MOD(INT(3 * (ROWS(H1:A1) - 1) / 3 ^ COLUMNS(H1:A1)), 3) + 1, 1)

" to A1, dragged cell A1 TO H1 then down 6561 rows but it did not work.

 

[Odurok]

It’s not working for me I’m using it on an iPhone

Try it with $H$1:A1 It should work then

 

[Steverico]

Thank you for that, and sorry for the confusion -- it's a standard name in my template workbook.

	A​	B​	C​	D​	E​	F​	G​	H​
1​	H	H	H	H	H	H	H	H
2​	H	H	H	H	H	H	H	D
3​	H	H	H	H	H	H	H	A
4​	H	H	H	H	H	H	D	H
5​	H	H	H	H	H	H	D	D
6​	H	H	H	H	H	H	D	A
7​	H	H	H	H	H	H	A	H
8​	H	H	H	H	H	H	A	D
9​	H	H	H	H	H	H	A	A
10​	…	…	…	…	…	…	…	…

Can I get the whole table please

 

[benjiemasungwa]

In A1,

=MID("HDA", MOD(INT(3 * (ROWS($H$1:Me) - 1) / 3 ^ COLUMNS($H$1:Me)), 3) + 1, 1)

Copy to H1 then down 6561 rows.

This is the best answer. Thank you very much. It was helpful.