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.
3 Replies
This is not possible in Excel??
Hi Peter,
General answer - it shall be possible.
Similar cases are, for example, here
http://www.excelforum.com/excel-general/596215-listing-all-combinations.html
https://www.get-digital-help.com/2015/02/26/return-all-combinations/
If more concrete, how to do that in your concrete case - have no ready to use pattern.
- Thank you so much sir, I was searching solution for the same type of combination for last few days, searched everywhere but no result but now i hv solution because of you.
thanks you heartly
