Getting a Table of 729 outcomes in 6 football matches.

Kahindi

New Member
Joined
Dec 30, 2022
Messages
12
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
Hello, guys. I need your help getting a table of 729 possible outcomes in 6 football matches. Please help me. Thanks.
 
  • Like
Reactions: efa

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
I don't think I understand your question.
With 6 football matches you have 18 possible outcomes. In each game there are 3 options(team A wins, Draw, team B wins).
 
Upvote 0
I don't think I understand your question.
With 6 football matches you have 18 possible outcomes. In each game there are 3 options(team A wins, Draw, team B wins).

If 3 football matches have 27 outcomes. Then 6 games can never be 18 outcomes. Outcomes are 729. What I need is the tables containing the all the outcomes. I stand to be corrected.
 
Last edited by a moderator:
  • Like
Reactions: efa
Upvote 1
Definetly not a neet solution, but for this example it should work



Sub gamescores()

Dim count As Integer
Dim sheetName As String
Dim ws As Worksheet
Dim score(2) As String

score(0) = "Team A Win"
score(1) = "Team B Win"
score(2) = "Draw"
sheetName = "matches"
count = 1

Set ws = ThisWorkbook.Sheets(sheetName)

For i = 0 To 2

For j = 0 To 2

For k = 0 To 2

For x = 0 To 2

For y = 0 To 2

For Z = 0 To 2

ws.Cells(count, 1).Value = "Outcome " & count
ws.Cells(count, 2).Value = score(i)
ws.Cells(count, 3).Value = score(j)
ws.Cells(count, 4).Value = score(k)
ws.Cells(count, 5).Value = score(x)
ws.Cells(count, 6).Value = score(y)
ws.Cells(count, 7).Value = score(Z)
count = count + 1

Next
Next
Next
Next
Next
Next

End Sub
 
Upvote 1
VBA Code:
Sub gamescores()

    Dim count As Integer
    Dim sheetName As String
    Dim ws As Worksheet
    Dim score(2) As String
   
    score(0) = "Team A Win"
    score(1) = "Team B Win"
    score(2) = "Draw"
    sheetName = "matches"
    count = 1
   
    Set ws = ThisWorkbook.Sheets(sheetName)
   
    For i = 0 To 2
       
        For j = 0 To 2
       
            For k = 0 To 2
               
                For x = 0 To 2
                   
                    For y = 0 To 2
                   
                        For Z = 0 To 2
                           
                            ws.Cells(count, 1).Value = "Outcome " & count
                            ws.Cells(count, 2).Value = score(i)
                            ws.Cells(count, 3).Value = score(j)
                            ws.Cells(count, 4).Value = score(k)
                            ws.Cells(count, 5).Value = score(x)
                            ws.Cells(count, 6).Value = score(y)
                            ws.Cells(count, 7).Value = score(Z)
                            count = count + 1
                           
                        Next
                    Next
                Next
            Next
        Next
    Next
   
End Sub
 
Last edited by a moderator:
Upvote 0
VBA Code:
Sub gamescores()

    Dim count As Integer
    Dim sheetName As String
    Dim ws As Worksheet
    Dim score(2) As String
  
    score(0) = "Team A Win"
    score(1) = "Team B Win"
    score(2) = "Draw"
    sheetName = "matches"
    count = 1
  
    Set ws = ThisWorkbook.Sheets(sheetName)
  
    For i = 0 To 2
      
        For j = 0 To 2
      
            For k = 0 To 2
              
                For x = 0 To 2
                  
                    For y = 0 To 2
                  
                        For Z = 0 To 2
                          
                            ws.Cells(count, 1).Value = "Outcome " & count
                            ws.Cells(count, 2).Value = score(i)
                            ws.Cells(count, 3).Value = score(j)
                            ws.Cells(count, 4).Value = score(k)
                            ws.Cells(count, 5).Value = score(x)
                            ws.Cells(count, 6).Value = score(y)
                            ws.Cells(count, 7).Value = score(Z)
                            count = count + 1
                          
                        Next
                    Next
                Next
            Next
        Next
    Next
  
End Sub
I would be glad if I get the table ready containing the ountcomes from you. I beg
 
Upvote 0
Is this what you want?
Fluff.xlsm
ABCDEF
1A winsA winsA winsA winsA winsA wins
2A winsA winsA winsA winsA winsB wins
3A winsA winsA winsA winsA winsDraw
4A winsA winsA winsA winsB winsA wins
5A winsA winsA winsA winsB winsB wins
6A winsA winsA winsA winsB winsDraw
7A winsA winsA winsA winsDrawA wins
8A winsA winsA winsA winsDrawB wins
9A winsA winsA winsA winsDrawDraw
10A winsA winsA winsB winsA winsA wins
11A winsA winsA winsB winsA winsB wins
12A winsA winsA winsB winsA winsDraw
13A winsA winsA winsB winsB winsA wins
14A winsA winsA winsB winsB winsB wins
15A winsA winsA winsB winsB winsDraw
16A winsA winsA winsB winsDrawA wins
17A winsA winsA winsB winsDrawB wins
18A winsA winsA winsB winsDrawDraw
19A winsA winsA winsDrawA winsA wins
20A winsA winsA winsDrawA winsB wins
21A winsA winsA winsDrawA winsDraw
22A winsA winsA winsDrawB winsA wins
23A winsA winsA winsDrawB winsB wins
24A winsA winsA winsDrawB winsDraw
25A winsA winsA winsDrawDrawA wins
26A winsA winsA winsDrawDrawB wins
27A winsA winsA winsDrawDrawDraw
28A winsA winsB winsA winsA winsA wins
29A winsA winsB winsA winsA winsB wins
30A winsA winsB winsA winsA winsDraw
31A winsA winsB winsA winsB winsA wins
32A winsA winsB winsA winsB winsB wins
33A winsA winsB winsA winsB winsDraw
34A winsA winsB winsA winsDrawA wins
35A winsA winsB winsA winsDrawB wins
36A winsA winsB winsA winsDrawDraw
37A winsA winsB winsB winsA winsA wins
38A winsA winsB winsB winsA winsB wins
39A winsA winsB winsB winsA winsDraw
40A winsA winsB winsB winsB winsA wins
Main
Cell Formulas
RangeFormula
A1:F729A1=CHOOSE(MID(BASE(SEQUENCE(3^6,,0),3,6),SEQUENCE(,6),1)+1,"A wins","B wins","Draw")
Dynamic array formulas.
 
Upvote 0
Is this what you want?
Fluff.xlsm
ABCDEF
1A winsA winsA winsA winsA winsA wins
2A winsA winsA winsA winsA winsB wins
3A winsA winsA winsA winsA winsDraw
4A winsA winsA winsA winsB winsA wins
5A winsA winsA winsA winsB winsB wins
6A winsA winsA winsA winsB winsDraw
7A winsA winsA winsA winsDrawA wins
8A winsA winsA winsA winsDrawB wins
9A winsA winsA winsA winsDrawDraw
10A winsA winsA winsB winsA winsA wins
11A winsA winsA winsB winsA winsB wins
12A winsA winsA winsB winsA winsDraw
13A winsA winsA winsB winsB winsA wins
14A winsA winsA winsB winsB winsB wins
15A winsA winsA winsB winsB winsDraw
16A winsA winsA winsB winsDrawA wins
17A winsA winsA winsB winsDrawB wins
18A winsA winsA winsB winsDrawDraw
19A winsA winsA winsDrawA winsA wins
20A winsA winsA winsDrawA winsB wins
21A winsA winsA winsDrawA winsDraw
22A winsA winsA winsDrawB winsA wins
23A winsA winsA winsDrawB winsB wins
24A winsA winsA winsDrawB winsDraw
25A winsA winsA winsDrawDrawA wins
26A winsA winsA winsDrawDrawB wins
27A winsA winsA winsDrawDrawDraw
28A winsA winsB winsA winsA winsA wins
29A winsA winsB winsA winsA winsB wins
30A winsA winsB winsA winsA winsDraw
31A winsA winsB winsA winsB winsA wins
32A winsA winsB winsA winsB winsB wins
33A winsA winsB winsA winsB winsDraw
34A winsA winsB winsA winsDrawA wins
35A winsA winsB winsA winsDrawB wins
36A winsA winsB winsA winsDrawDraw
37A winsA winsB winsB winsA winsA wins
38A winsA winsB winsB winsA winsB wins
39A winsA winsB winsB winsA winsDraw
40A winsA winsB winsB winsB winsA wins
Main
Cell Formulas
RangeFormula
A1:F729A1=CHOOSE(MID(BASE(SEQUENCE(3^6,,0),3,6),SEQUENCE(,6),1)+1,"A wins","B wins","Draw")
Dynamic array formulas.
I don't see Loses. I only see wins and draws. And should be 729 outcomes im thr excel sheet. I will really appreciate when one gets the sheet nicely.
 
Upvote 0
Is this what you want?
Fluff.xlsm
ABCDEF
1A winsA winsA winsA winsA winsA wins
2A winsA winsA winsA winsA winsB wins
3A winsA winsA winsA winsA winsDraw
4A winsA winsA winsA winsB winsA wins
5A winsA winsA winsA winsB winsB wins
6A winsA winsA winsA winsB winsDraw
7A winsA winsA winsA winsDrawA wins
8A winsA winsA winsA winsDrawB wins
9A winsA winsA winsA winsDrawDraw
10A winsA winsA winsB winsA winsA wins
11A winsA winsA winsB winsA winsB wins
12A winsA winsA winsB winsA winsDraw
13A winsA winsA winsB winsB winsA wins
14A winsA winsA winsB winsB winsB wins
15A winsA winsA winsB winsB winsDraw
16A winsA winsA winsB winsDrawA wins
17A winsA winsA winsB winsDrawB wins
18A winsA winsA winsB winsDrawDraw
19A winsA winsA winsDrawA winsA wins
20A winsA winsA winsDrawA winsB wins
21A winsA winsA winsDrawA winsDraw
22A winsA winsA winsDrawB winsA wins
23A winsA winsA winsDrawB winsB wins
24A winsA winsA winsDrawB winsDraw
25A winsA winsA winsDrawDrawA wins
26A winsA winsA winsDrawDrawB wins
27A winsA winsA winsDrawDrawDraw
28A winsA winsB winsA winsA winsA wins
29A winsA winsB winsA winsA winsB wins
30A winsA winsB winsA winsA winsDraw
31A winsA winsB winsA winsB winsA wins
32A winsA winsB winsA winsB winsB wins
33A winsA winsB winsA winsB winsDraw
34A winsA winsB winsA winsDrawA wins
35A winsA winsB winsA winsDrawB wins
36A winsA winsB winsA winsDrawDraw
37A winsA winsB winsB winsA winsA wins
38A winsA winsB winsB winsA winsB wins
39A winsA winsB winsB winsA winsDraw
40A winsA winsB winsB winsB winsA wins
Main
Cell Formulas
RangeFormula
A1:F729A1=CHOOSE(MID(BASE(SEQUENCE(3^6,,0),3,6),SEQUENCE(,6),1)+1,"A wins","B wins","Draw")
Dynamic array formulas.
Might be correct sir but I don't see loses and should be 729 total outcomes. Maybe I see another sheet from you. I will appreciate
 
Upvote 0
In that case you need to show us exactly what you are after.
 
Upvote 0

Forum statistics

Threads
1,223,287
Messages
6,171,199
Members
452,390
Latest member
kemafa77

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top