Pairings. Round Robin 3 Team Parlays

[wadeger]

Okay....this is to be used for sports betting, especially related to round robins....a round robin is for example, i pick 5 teams (for example, Team A, Team B, Team C, Team D, and Team E)......i want to input the following in one cell;

Number of Teams X

if X=5 in this example, and I want 3 team parlays for all 5 teams, it would be the following groupings;

ABC
ABD
ABE
ACD
ACE
ADE
BCD
BCE
BDE
CDE

with 5 teams chosen, it makes 10 groupings, but if the Number of teams is 12, i think it would make 220 groupings.

My question is how do I get excel to automatically create these groupings once the number of teams is chosen?

Thank you for any help I can be given.

 

[wadeger]

Please help me if you can. My work on this spreadsheet has come to a halt. Thank you.

Okay....this is to be used for sports betting, especially related to round robins....a round robin is for example, i pick 5 teams (for example, Team A, Team B, Team C, Team D, and Team E)......i want to input the following in one cell;

Number of Teams X

if X=5 in this example, and I want 3 team parlays for all 5 teams, it would be the following groupings;

ABC
ABD
ABE
ACD
ACE
ADE
BCD
BCE
BDE
CDE

with 5 teams chosen, it makes 10 groupings, but if the Number of teams is 12, i think it would make 220 groupings.

My question is how do I get excel to automatically create these groupings once the number of teams is chosen?

Thank you for any help I can be given.