How to generate sports betting possibility for 13 teams

[jamoo]

Hello Excel lent people

My challenge is i would like to generate all betting possibility in a 13 Matches,with 2 games each ,with usual outcomes of 1,X.2
such that there will be 3^13 outcomes -1594323 results,

I dont know much about Excel/VBA formulas but i would really like to have a combinations generator .kindly assist/advise

jamoo

 

[footoo]

It works for me - fills 1,594,323 cells, so nothing missing.

Try using Find for ADADA* (match entire cell contents, Find Next).

 

[jamoo]

Thanks a lot team