How to generate all possible combinations of items from one list in excel

    how to create combinations in excel
    how to make combinations in excel formula
    how to create random combinations in excel
    how to create number combinations in excel
  • How to create combinations in excel

    • Combination generator excel download!

    You can use the following formula to list all possible combinations between multiple lists in Excel:

    =IF(ROW()-ROW($D$2)+1>COUNTA($A$2:$A$4)*COUNTA($B$2:$B$4),"",INDEX($A$2:$A$4,INT((ROW()-ROW($D$2))/COUNTA($B$2:$B$4)+1))&" "&INDEX($B$2:$B$4,MOD(ROW()-ROW($D$2),COUNTA($B$2:$B$4))+1))

    This particular formula lists all possible combinations between the values in the range A2:A4 and the range B2:B4, and outputs these combinations starting in cell D2.

    The following example shows how to use this formula in practice.

    Example: List All Possible Combinations Between Multiple Lists in Excel

    Suppose we have a list of basketball team names and a list of positions:

    Suppose we would like to list all possible combinations between the team names and the positions.

    To do so, we can type the following formula into cell D2:

    =IF(ROW()-ROW($D$2)+1>COUNTA($A$2:$A$4)*COUNTA($B$2:$B$4),"",INDEX($A$2:$A$4,INT((ROW()-ROW($D$2))/COUNTA($B$2:$B$4)+1))&" "&INDEX($B$2:$B$4,MOD(ROW()-ROW($D$2),COUNTA($B$2:$B$4))+1))

    We can then click and drag this formula down to mor

      how to create multiple combinations in excel
      how to create unique combinations in excel