+ Reply to Thread
Results 1 to 7 of 7

Request = how many trainings are possible for 1,2,3,4,5,6

  1. #1
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Request = how many trainings are possible for 1,2,3,4,5,6

    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 ????

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Request = how many trainings are possible for 1,2,3,4,5,6

    =permut(6,6)
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: Request = how many trainings are possible for 1,2,3,4,5,6

    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

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Request = how many trainings are possible for 1,2,3,4,5,6

    A
    B
    C
    D
    E
    F
    G
    H
    1
    1
    1
    2
    3
    3
    4
    180
    G1: {=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

  5. #5
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Request = how many trainings are possible for 1,2,3,4,5,6

    jorel: Did you look at the PERMUT function in Excel's Help file?

  6. #6
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: Request = how many trainings are possible for 1,2,3,4,5,6

    ok SHG yes, thank you
    macro pod ok yes! thank you

  7. #7
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Request = how many trainings are possible for 1,2,3,4,5,6

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Wait for winhttp request to be done (much like XML http request)
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 07-23-2015, 09:26 AM
  2. Faster Code - Add employee with different trainings
    By Eoam13 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-04-2015, 08:26 AM
  3. Checking if employees have completed trainings? Vlookup, countifs, ... ?
    By begexcel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-12-2014, 05:47 PM
  4. VBA Help Request
    By Beckye in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-18-2014, 07:39 PM
  5. Replies: 1
    Last Post: 01-07-2014, 03:06 AM
  6. MS Excel 2010 Video Trainings
    By alexey.k in forum Excel General
    Replies: 2
    Last Post: 08-14-2013, 02:35 AM
  7. Replies: 2
    Last Post: 03-11-2013, 09:59 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1