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...
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
all the value in the table above is calculated manually and it wasting my time an paper,, LoL,, because i have to write down all possible permutation and count it...
can someone help me with this...
Thank You
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 |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1
all the value in the table above is calculated manually and it wasting my time an paper,, LoL,, because i have to write down all possible permutation and count it...
can someone help me with this...
Thank You
Last edited: