Unique Permutation Combinations

**Clemence** · 07-20-2015, 09:52 AM

Hi Guys,

I am looking for a code to create possible permutation combinations from a list for words/categories.

a
b
c
d
e

result:
a
ab
ac
ad
abc
abd
abe
abf
abg
acb
acd
ace
acf
acg
adb
adc
ade
........
abcde
abced
abdce
adbce
........

example:
I create a column with possible categories / words:

a
b
c
d
e
f
g

In a Form of a Dashboard e.g. Matrix: I want to control how many (n) Combinations I would like to create. I also want to determine the first word.

e.g.

Master	Sub	Sub1	Sub2	Sub3	Sub4
TRUE	TRUE	TRUE	FALSE	FALSE	FALSE
a
a	b
a	c
a	d
a	b	c
a	b	d
a	b	e
a	b	f
a	b	g
a	c	b
a	c	d
a	c	e
a	c	f
a	c	g
a	d	b
a	d	c
a	d	e
.....	.....	......

I really appreciate the help! I know, that first there must be a loop to check if Cells(2,i) are TRUE or FALSE
and if TRUE, then write into the specific columns the permutations.....

Alternatively to putting: TRUE or FALSE to the second row for the Word-Combinations - an Idea would also be just a dropdown with: [Master + 1] ; [Master+2] etc. for how many words should be combined.

Thanks a lot! You guys really are pro!