Hi,
I have three columns with values in all cells.
I would like to see all possible combinations of 1 value from column A, 1 from column B and 1 from column C. Thus the order does not matter (I am looking for combinations, not permutations).
Please find attached an example sheet with a few of the values from my data (2 from column A, 3 from column B and 4 from column C). I have listed the 24 possible combinations "manually" myself. I would like Excel to be able to return these combinations, though, as for all my data the total amount of possible combinations is 8,820 and this number could potentially increase to +100,000 in the future.
Best regards
Kasper
Bookmarks