How to display all possible combinations of the alphabet ?

[weird]

Hello,

Is it possible to automatically display in excel every possible combination of the alphabet (or contents in a column), showing every possible combination ...,

so the ouput would be similar to this ...

A
B
C
D
E
F ... etc

AB
AC
AD ... etc

ABC
ABD
ABE ... etc

ACD ...
ACE ... etc

BC
BD
BE ... etc

BCD
BCE
BCF ... etc

BDE ...
BDF ... etc

etc


Many thanks in advance

[Carim]

Hi,

As far as permutations are concerned, take a look at following tip ...
http://www.j-walk.com/ss/excel/tips/tip46.htm

HTH
Carim

[weird]

Thanks Carim

Very interesting, although not really what I am after. More interested in all "combinations" of any individual row in a column (example alphabet from A1-A26), displayed such as in the example above, but not permutations.

Very interesting none the less. Thanks.

[weird]

Actually reviewing the problem I wish to solve, the problem is more difficult than I originally anticipated,

Require display combination of "state" - row and "list" - column, where each state (colA,ColB) is the opposite of each other so would not occur
in a valid combination,

So example of data,

A0 A1
B0 B1
C0 C1
D0 D1
E0 E1
F0 F1
G0 G1
H0 H1
I0 I1
J0 J1
K0 K1
L0 L1
M0 M1
N0 N1
O0 O1
P0 P1
Q0 Q1
R0 R1
S0 S1
T0 T1
U0 U1
V0 V1
W0 W1
X0 X1
Y0 Y1
Z0 Z1

Require display to appear similar to below, and order is not important, so not a permutation.

A0
A0B0
A0B1 .. etc

A0B0C0
A0B0C1 ... etc

A0B1C0
A0B1C1 ... etc

B0C0
B0C1 ... etc

[oldchippy]

I think the possible combinations that are possible is 10,400,600 using the 26 letters of the alphabet - not enough rows in Excel unfortunately

=COMBIN(26,13)