Request = how many trainings are possible for 1,2,3,4,5,6
Example =
.. If you have 6 numbers of delta numbers: 1-2-3-4-5-6 box will be:
1-2-3-5-4-6
1-6-2-3-4-5
6-1-2-3-4-5
and so on....
is 720 or more ????
Request = how many trainings are possible for 1,2,3,4,5,6
Example =
.. If you have 6 numbers of delta numbers: 1-2-3-4-5-6 box will be:
1-2-3-5-4-6
1-6-2-3-4-5
6-1-2-3-4-5
and so on....
is 720 or more ????
=permut(6,6)
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
hello macropod
Hello and with repetition
Example 1,1,3,3,2,4
Can you repeat with a maximum of three repeated digits in the formation? Please
A B C D E F G H 1 1 1 2 3 3 4 180G1: {=PERMUT(COUNT(A1:F1), COUNT(A1:F1)) / PRODUCT(FACT(COUNTIF(A1:F1, {1,2,3,4,5,6})))}
It's the number of k-permutations of a k-symbol string divided by the product of the factorials of the number of repetitions of each symbol.
Google permutations of mississippi
Last edited by shg; 10-03-2017 at 12:55 AM.
Entia non sunt multiplicanda sine necessitate
jorel: Did you look at the PERMUT function in Excel's Help file?
ok SHG yes, thank you
macro pod ok yes! thank you
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks