[Branson]

How do I get a listing of a factorial.

Example.

Factorial of A,B,C
Factorial 3! = 6
Listing
ABC
BAC
CAB
ACB
CBA
BCA

How do I get a Factorial listing of "X" number of choices.

Factorial of (A1,B1,C1) where A1 = Bill, B1 = Fred, C1 = Sam

All different combinations using each name one time.

Any help please.

Thanks

[Gary''s Student]

See:

http://groups.google.com/group/micro...e 1d8dea66bf8


--
Gary''s Student - gsnu200790


"Branson" wrote:

How do I get a listing of a factorial.

Example.

Factorial of A,B,C
Factorial 3! = 6
Listing
ABC
BAC
CAB
ACB
CBA
BCA

How do I get a Factorial listing of "X" number of choices.

Factorial of (A1,B1,C1) where A1 = Bill, B1 = Fred, C1 = Sam

All different combinations using each name one time.

Any help please.

Thanks

[Bernard Liengme]

It would take far to long to answer this. I suggest you got to Google and
find Google Groups. Seach with: EXCEL COMBINATIONS (that is the word you
are looking for). The topic has been covered many times in detail
best wishes
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Branson" wrote in message
...
How do I get a listing of a factorial.

Example.

Factorial of A,B,C
Factorial 3! = 6
Listing
ABC
BAC
CAB
ACB
CBA
BCA

How do I get a Factorial listing of "X" number of choices.

Factorial of (A1,B1,C1) where A1 = Bill, B1 = Fred, C1 = Sam

All different combinations using each name one time.

Any help please.

Thanks

[Andrea Jones]

There's a method for doing that here
http://www.j-walk.com/SS/excel/tips/tip46.htm

Andrea Jones
www.stratatraining.co.uk

"Branson" wrote:

How do I get a listing of a factorial.

Example.

Factorial of A,B,C
Factorial 3! = 6
Listing
ABC
BAC
CAB
ACB
CBA
BCA

How do I get a Factorial listing of "X" number of choices.

Factorial of (A1,B1,C1) where A1 = Bill, B1 = Fred, C1 = Sam

All different combinations using each name one time.

Any help please.

Thanks