Excel: Calculate how many PERMUTATION possible


Hello Me Excel... I really need help again here... I want to calculate for how many permutation possible for number in cell.. just for example: in collumn A have list of number or letters column B is permut by 6 column C is permut by 5 and etc...

A B C D E F
1 Number/Letters Permute 6 Permute 5 permute 4 Permute 3 Permute 2
2 abcd 24 24 12
3 aabc 12 12 7
4 aaab 4 4 3
5 aabb 6 6 4
6 abcde 120 120 60 20
7 aabcd 60 33 13
8 aabbc 30 18 8
9 abcdef 720 720 360 120 30
10 aabcde
11 aaabcd
12 aabbcd
[CENTER]Sheet1[/CENTER] all the value in the table above is calculated manually and it wasting my time an paper,, LoL,,:laugh: because i have to write down all possible permutation and count it... can someone help me with this... Thank You


This question generated 32 answers. To proceed to the answers, click here.

This thread is current as of January 20, 2014.


For more resources for Microsoft Excel