Possible Combinations from a single list.

[Sarravana Kumar]

Hi all,

Request your help pls & TIA.

I have a List

A
B
C
D
E
F
G
H
I
J

I need to create a list of all possible combinations

Ex:
A B C D E F G H I J
A B C D E F G H I
A B C D E F G H
A B C D E F G
A B
C D
A B C
A
B
C
D E F
D E
.
.
.
.
.
.

 

[AlanSidman]

Here are links to possible solutions

listing all combinations

if i had the letters A,B,C,D,E,F,G,H,I in cells A1 thru A9, how could i show all combinations of these nine letters (one letter per cell) in columns B thru J? this would include A, B, AB, ABC, ABCD, etc. per the formula for combinations without replacement, i know i should end up with 511...

www.excelforum.com

Return all combinations

Today I have two functions I would like to demonstrate, they calculate all possible combinations from a cell range. What is a combination? To explain combin

www.get-digital-help.com

Note: I tested the first solution and it ran almost instantaneously. Good Job for Mike Erikson developing this.

 

[Sarravana Kumar]

Thanks a ton for the timely guidance.