Generate all possible combinations of 8 football games (1X2) and add some requirements

Hi,

I have a question regarding the possible combinations of 8 football games with 3 possible outcomes.

I have it down as this:

MATCH	HOME	DRAW	AWAY
1	1	X	2
2	1	X	2
3	1	X	2
4	1	X	2
5	1	X	2
6	1	X	2
7	1	X	2
8	1	X	2

I want to be able to print out all 6561 combinations in excel.
And to get results like:
1,1,1,1,1,1,1,1
1,1,1,1,1,1,1,X
.
.
.
2,2,2,2,2,2,2,X
2,2,2,2,2,2,2,2

In other words, all possible combinations.


I would also like to add another row besides it where I have the percentage of every outcome between the teams multiplied. Simple example below:

MATCH	HOMEp	DRAWp	AWAYp
1	0.6	0.3	0.1
2	0.4	0.4	0.2
3	0.1	0.5	0.4
4	0.8	0.1	0.1
5	0.7	0.1	0.2
6	0.6	0.2	0.2
7	0.2	0.4	0.4
8	0.6	0.3	0.1

So that every unique combination has a probability that corresponds to it. For example the outcome 1,1,1,1,1,1,1,1 would have the probability 0.6*0.4*0.1*0.8*0.7*0.6*0.2*0.6 = 0.00096768.

Or if it's possible to put in a requirement that only prints the outcomes which corresponds to a probability above a certain value, let's say 0.0005. So instead of printing 6561 combinations, it prints maybe 300.

I have tried and tried, but nothing seems to work for me, so any help would be very appreciated.

FootballStatistician welcome to the forum.

Please complete your profile to reflect the product and version you want this to work in.

The best solutions often rely on knowing WHICH Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date. If you aren't sure, in Excel go to File/Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this.

The three most recent Excel PRODUCTS are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the Version number in your profile (e.g. MS365 (PC) Version 2211). The version number is in the About Excel section further down the Account page.

Also:

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

Originally Posted by FootballStatistician

Thank you for the assistance. I have uploaded an excel document now and added Excel 2021 (MAC) to my profile. However It also says "Version 16.54 (21101001). I am unsure if this is the important info as I have a Microsoft 365 Subscription.

Since I am not familiar with Mac I cannot comment on the version numbers. What you have done is likely sufficient. Do check / update your product from time to time. Those updates often introduce new features/functions creating new solution possibilities. It helps us to help you.

Thank you again for updating your profile.