Determine all unique combinations

[rdy-csci]

I am hoping to accomplish this in excel if possible. I have a list of 8 values in column A. I need to determine all possible combinations of these values and place them in column B. Is there a way to do this with VB macros or excel formulas?

so...

Column1
A
B
C
D
E
F
G
H

Column2
A
AB
ABC
ABCD
ABCDE
ABCDEF
ABCDEFG
ABCDEFGH
AC
ACD
ACDE
ACDEF
ACDEFG
ACDEFGH
AD
ADE
ADEF
ADEFG
ADEFGH
etc. etc.

continue for each value.

Note: ABC is the same as BAC or CAB in my case, so I do not need to include variations that are the same just in a different order. Simply all the combinations.

 

[pgc01]

Hi
Welcome to the board

I posted some solutions, for different options. I guess that what you want is the powerset, which is the first solution in the thread.

http://www.mrexcel.com/forum/showthread.php?t=435865

 

[rdy-csci]

Clarification: I just need all the combinations, the results do not have to be in a specific column.

 

[rdy-csci]

Thanks, I'll check out that forum