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!!!!

 

[West Man]

It can be done several different ways, but do you really want all 6.561 outcomes?

 

[shg]

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.

 

[Efuentes26]

It can be done several different ways, but do you really want all 6.561 outcomes?

I thought there is only 512 outcomes for 8 matches.

 

[jasmith4]

I get a #NAME? error in Excel 2010. Change "Me" to "A1" -- no dollar signs -- and it will be correct.

 

[West Man]

I thought there is only 512 outcomes for 8 matches.

3^8=6561 which is confirmed by shg"s solution (which I like very much)

 

[Efuentes26]

Yes I need the all outcomes listed please.

 

[shg]

I get a #NAME? error in Excel 2010. Change "Me" to "A1" -- no dollar signs -- and it will be correct.

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​	…	…	…	…	…	…	…	…

 

[keliphy]

Hello, please what do i do in the case of 6 soccer matches?
your prompt response would be highly appreciated.
thanks.

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.

 

[keliphy]

I thought there is only 512 outcomes for 8 matches.

Hello, can u kindly help with the other ways these can be done? in the case of 6 soccer matches tho'
Thank you.