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:
