Efuentes26
New Member
- Joined
- Jan 28, 2014
- Messages
- 3
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!!!!
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!!!!