Forum Discussion
Simple List of Combinations From Single Row Table
Note: Novice User, using Excel 2013.
I want to create a non-repeating list of possible combinations/permutations from a single column table.
I want to make a simple table called "letters". The number of items will vary. I'm using alphabet characters in the example but imagine these could be easily apples, oranges, salad, drink....and so on.
In a separate tab I want to generate a list of non-repeating combinations, order does not matter, and I want to run this list in varying string length (1x, 2x, 3x, 4x, ...) until final result with all items combined. Sample output I imagine would be:
A
B
C
D
AB
AC
AD
BC
BD
CD
ABC
ABD
BCD
CDA
ABCD
If possible from formatting perspective, I would like to display the combinations separated by "+" character.
Any help would be appreciated.