Factorial Listing

B

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
 
B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

largest factorial that can be computed 3
Counting unique combinations in two columns 3
Help with sumproduct or similar type of function 0
Data Validation List 1
run programme error occuring 2
programme run help 2
Unique Value Count in 3 Columns Using Search Criteria 0
HELP on conditional formatting 6

Top