View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Branson Branson is offline
external usenet poster
 
Posts: 1
Default Factorial Listing

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