Posted to microsoft.public.excel.misc
|
|
Factorial Listing
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
|