Is there a way for Excel to LIST all possible combinations of a given range of letters or numbers?
Example:
Team A plays Team B
Team C plays Team D
Team E plays Team F
A&B can not be in the same combination, just like C&D and E&F can not be, because only one of the teams going head to head can win.
I know that there are 8 possible combinations:
ACE, ADE, ADF, ACF, BDF, BDE, BCE, BCF
So can Excel produce this list if I reference the team names in any given cells?
Example:
Team A plays Team B
Team C plays Team D
Team E plays Team F
A&B can not be in the same combination, just like C&D and E&F can not be, because only one of the teams going head to head can win.
I know that there are 8 possible combinations:
ACE, ADE, ADF, ACF, BDF, BDE, BCE, BCF
So can Excel produce this list if I reference the team names in any given cells?