Getting a Table of 729 outcomes in 6 football matches.

[Kahindi]

Hello, guys. I need your help getting a table of 729 possible outcomes in 6 football matches. Please help me. Thanks.

 

[Kahindi]

In that case you need to show us exactly what you are after.

Just an assignment given

 

[Fluff]

In that case you should have said that at the beginning, we are not here to do your homework for you.
That said you must have been told what the expected results are.

 

[Kahindi]

In that case you should have said that at the beginning, we are not here to do your homework for you.
That said you must have been told what the expected results are.

I know it's 729 outcomes. But to have the table sheet is what gives me headache. Sorry for disturbing but I will be glad to get asisstance. It's me trying to find the sheet. So it's my assignment trying to get the sheet. Thanks

 

[Fluff]

You have still not showed us what the expected result & so we have no way of knowing what you want.

 

[Kahindi]

H

You have still not showed us what the expected result & so we have no way of knowing what you want.

How did you understand my query? Maybe I can know what am missing on my end?

 

[Joe4]

Please follow these guidelines when posting questions, so you can clearly communicate/demonstrate what your expected results should look like:

Guidelines

Guidelines for MrExcel Message Board Use

www.mrexcel.com

 

[Kahindi]

Hey. Am back. Sorryfor not being clear. Here is the question. I need sheet showing all the possible outcomes of 6 Football games. The outcomes should be for example HHHHHH, HHHHHA, HHHHHD, etc. Where H-Home
A-Away
D-Draw.

Have tried seeing how I will get the sheet to no avail. A good samarita to give me heads up. Thanks

 

[Joe4]

Hey. Am back. Sorryfor not being clear. Here is the question. I need sheet showing all the possible outcomes of 6 Football games. The outcomes should be for example HHHHHH, HHHHHA, HHHHHD, etc. Where H-Home
A-Away
D-Draw.

Have tried seeing how I will get the sheet to no avail. A good samarita to give me heads up. Thanks

It seems that the answers you got already do that.
Note that in Fluff's reply, how is "A wins" or "B wins" different from "H wins" or "A winds"?
Simply change the letters to whatever you want them to do be.

And tell us how exactly how it does not work for you.
Are you expecting each string of six possible results to appear in one cell like "HHHHHH" instead of being spread out over 6 individual cells?
Is that it, or is it something else you are looking for?

 

[Kahindi]

To appear in one cell like H

It seems that the answers you got already do that.
Note that in Fluff's reply, how is "A wins" or "B wins" different from "H wins" or "A winds"?
Simply change the letters to whatever you want them to do be.

And tell us how exactly how it does not work for you.
Are you expecting each string of six possible results to appear in one cell like "HHHHHH" instead of being spread out over 6 individual cells?
Is that it, or is it something else you are looking for?

It seems that the answers you got already do that.
Note that in Fluff's reply, how is "A wins" or "B wins" different from "H wins" or "A winds"?
Simply change the letters to whatever you want them to do be.

And tell us how exactly how it does not work for you.
Are you expecting each string of six possible results to appear in one cell like "HHHHHH" instead of being spread out over 6 individual cells?
Is that it, or is it something else you are looking for?

Yes, each string of six possible results to appear in one cell like HHHHHH. That's what i want.

 

[Fluff]

How about

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(BASE(SEQUENCE(3^6,,0),3,6),"0","H"),"1","A"),"2","D")