+ Reply to Thread
Results 1 to 9 of 9

Order = maximum 3 letters per decade

  1. 09-04-2017, 07:44 AM #1
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,344

    Order = maximum 3 letters per decade

    Order = maximum 3 letters per decade
    My lottery 80/5
    We have
    A = 01 02 03 04 05 06 07 08 09 10
    B = 11 12 13 14 ..... 20
    C = 21 22 23 .... 30
    D = 31 32 33 .... 40
    E = 41 42 43 ..... 50
    F = 51 52 53 .... 60
    G = 61 62 63 ..... 70
    H = 71 72 73 ..... 80
    Example
    Aaabb
    Aaacc
    Bccccc
    ....
    Maximum 3 letters and minimum one letter
    Go to aahhh
    Reply With QuoteRegister To Reply
  2. 09-04-2017, 07:45 AM #2
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,344

    Re: Order = maximum 3 letters per decade

    bcccc= error= maximum 3 letters
    Reply With QuoteRegister To Reply
  3. 09-04-2017, 01:19 PM #3
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,344

    Re: Order = maximum 3 letters per decade

    please!!help
    Reply With QuoteRegister To Reply
  4. 09-04-2017, 01:38 PM #4
    protonLeah
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,960

    Re: Order = maximum 3 letters per decade

    deleted request for file...
    Last edited by protonLeah; 09-04-2017 at 03:48 PM.
    Ben Van Johnson
    Reply With QuoteRegister To Reply
  5. 09-04-2017, 01:59 PM #5
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Order = maximum 3 letters per decade

    There only 7 ways to choose 5 numbers:

    5 from a single decade
    4 from one and 1 from a second
    3 from one and 2 from a second
    3 from one, 1 from a second, and 1 from a third
    2 from one, 2 from a second, and 1 from a third
    2 from one, 1 from a second, and 1 from a third, and 1 from a fourth
    1 from each of 5

    Your rule only excludes the first two ways, and includes 23,920,400 of the 24,040,016 combinations.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  6. 09-04-2017, 02:25 PM #6
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Order = maximum 3 letters per decade

    A
    B
    C
    D
    E
    F
    G
    H
    I
    1
    (Not OK)
    (Not OK)
    (OK)
    (OK)
    (OK)
    (OK)
    (OK)
    2
    Decade
    Choose
    Choose
    Choose
    Choose
    Choose
    Choose
    Choose
    3
    One decade
    5
    4
    3
    3
    2
    2
    1
    4
    Another decade
    1
    2
    1
    2
    1
    1
    5
    Another decade
    1
    1
    1
    1
    6
    Another decade
    1
    1
    7
    Another decade
    1
    8
    9
    		 Ways to choose decades
    8
    28
    28
    56
    56
    70
    56
    		B9: =COMBIN(8, COUNT(B3:B7))
    10
    		 Permutations of Counts w/in Decades
    1
    2
    2
    3
    3
    4
    1
    		B10: {=FACT(COUNT(B3:B7)) / PRODUCT(FACT(COUNTIF(B3:B7, {1,2,3,4,5})))}
    11
    		 Ways to choose within decades
    252
    2,100
    5,400
    12,000
    20,250
    45,000
    100,000
    		B11: {=PRODUCT(COMBIN(10, B3:B7))}
    12
    		 Combinations
    2,016
    117,600
    302,400
    2,016,000
    3,402,000
    12,600,000
    5,600,000
    		B12: =PRODUCT(B9:B11)
    13
    14
    		 Total Combinations
    24,040,016
    		H14: =SUM(B12:H12)
    15
    		 Check that
    24,040,016
    		H15: =COMBIN(80,5)
    16
    		 Total OK Combinations
    23,920,400
    		H16: =SUM(D12:H12)
    Last edited by shg; 09-04-2017 at 02:31 PM.
    Reply With QuoteRegister To Reply
  7. 09-04-2017, 02:39 PM #7
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,344

    Re: Order = maximum 3 letters per decade

    hello SHG exemplo this 60/6
    help 80/5 5 colunns
    a a a b b b
    a a a b b c
    a a a b b d
    a a a b b e
    a a a b b f
    a a a b c c
    a a a b c d
    a a a b c e
    a a a b c f
    a a a b d d
    a a a b d e
    a a a b d f
    a a a b e e
    a a a b e f
    a a a b f f
    a a a c c c
    a a a c c d
    a a a c c e
    a a a c c f
    a a a c d d
    a a a c d e
    a a a c d f
    a a a c e e
    a a a c e f
    a a a c f f
    a a a d d d
    a a a d d e
    a a a d d f
    a a a d e e
    a a a d e f
    a a a d f f
    a a a e e e
    a a a e e f
    a a a e f f
    a a a f f f
    a a b b b c
    a a b b b d
    a a b b b e
    a a b b b f
    a a b b c c
    a a b b c d
    a a b b c e
    a a b b c f
    a a b b d d
    a a b b d e
    a a b b d f
    a a b b e e
    a a b b e f
    a a b b f f
    a a b c c c
    a a b c c d
    a a b c c e
    a a b c c f
    a a b c d d
    a a b c d e
    a a b c d f
    a a b c e e
    a a b c e f
    a a b c f f
    a a b d d d
    a a b d d e
    a a b d d f
    a a b d e e
    a a b d e f
    a a b d f f
    a a b e e e
    a a b e e f
    a a b e f f
    a a b f f f
    a a c c c d
    a a c c c e
    a a c c c f
    a a c c d d
    a a c c d e
    a a c c d f
    a a c c e e
    a a c c e f
    a a c c f f
    a a c d d d
    a a c d d e
    a a c d d f
    a a c d e e
    a a c d e f
    a a c d f f
    a a c e e e
    a a c e e f
    a a c e f f
    a a c f f f
    a a d d d e
    a a d d d f
    a a d d e e
    a a d d e f
    a a d d f f
    a a d e e e
    a a d e e f
    a a d e f f
    a a d f f f
    a a e e e f
    a a e e f f
    a a e f f f
    a b b b c c
    a b b b c d
    a b b b c e
    a b b b c f
    a b b b d d
    a b b b d e
    a b b b d f
    a b b b e e
    a b b b e f
    a b b b f f
    a b b c c c
    a b b c c d
    a b b c c e
    a b b c c f
    a b b c d d
    a b b c d e
    a b b c d f
    a b b c e e
    a b b c e f
    a b b c f f
    a b b d d d
    a b b d d e
    a b b d d f
    a b b d e e
    a b b d e f
    a b b d f f
    a b b e e e
    a b b e e f
    a b b e f f
    a b b f f f
    a b c c c d
    a b c c c e
    a b c c c f
    a b c c d d
    a b c c d e
    a b c c d f
    a b c c e e
    a b c c e f
    a b c c f f
    a b c d d d
    a b c d d e
    a b c d d f
    a b c d e e
    a b c d e f
    a b c d f f
    a b c e e e
    a b c e e f
    a b c e f f
    a b c f f f
    a b d d d e
    a b d d d f
    a b d d e e
    a b d d e f
    a b d d f f
    a b d e e e
    a b d e e f
    a b d e f f
    a b d f f f
    a b e e e f
    a b e e f f
    a b e f f f
    a c c c d d
    a c c c d e
    a c c c d f
    a c c c e e
    a c c c e f
    a c c c f f
    a c c d d d
    a c c d d e
    a c c d d f
    a c c d e e
    a c c d e f
    a c c d f f
    a c c e e e
    a c c e e f
    a c c e f f
    a c c f f f
    a c d d d e
    a c d d d f
    a c d d e e
    a c d d e f
    a c d d f f
    a c d e e e
    a c d e e f
    a c d e f f
    a c d f f f
    a c e e e f
    a c e e f f
    a c e f f f
    a d d d e e
    a d d d e f
    a d d d f f
    a d d e e e
    a d d e e f
    a d d e f f
    a d d f f f
    a d e e e f
    a d e e f f
    a d e f f f
    a e e e f f
    a e e f f f
    b b b c c c
    b b b c c d
    b b b c c e
    b b b c c f
    b b b c d d
    b b b c d e
    b b b c d f
    b b b c e e
    b b b c e f
    b b b c f f
    b b b d d d
    b b b d d e
    b b b d d f
    b b b d e e
    b b b d e f
    b b b d f f
    b b b e e e
    b b b e e f
    b b b e f f
    b b b f f f
    b b c c c d
    b b c c c e
    b b c c c f
    b b c c d d
    b b c c d e
    b b c c d f
    b b c c e e
    b b c c e f
    b b c c f f
    b b c d d d
    b b c d d e
    b b c d d f
    b b c d e e
    b b c d e f
    b b c d f f
    b b c e e e
    b b c e e f
    b b c e f f
    b b c f f f
    b b d d d e
    b b d d d f
    b b d d e e
    b b d d e f
    b b d d f f
    b b d e e e
    b b d e e f
    b b d e f f
    b b d f f f
    b b e e e f
    b b e e f f
    b b e f f f
    b c c c d d
    b c c c d e
    b c c c d f
    b c c c e e
    b c c c e f
    b c c c f f
    b c c d d d
    b c c d d e
    b c c d d f
    b c c d e e
    b c c d e f
    b c c d f f
    b c c e e e
    b c c e e f
    b c c e f f
    b c c f f f
    b c d d d e
    b c d d d f
    b c d d e e
    b c d d e f
    b c d d f f
    b c d e e e
    b c d e e f
    b c d e f f
    b c d f f f
    b c e e e f
    b c e e f f
    b c e f f f
    b d d d e e
    b d d d e f
    b d d d f f
    b d d e e e
    b d d e e f
    b d d e f f
    b d d f f f
    b d e e e f
    b d e e f f
    b d e f f f
    b e e e f f
    b e e f f f
    c c c d d d
    c c c d d e
    c c c d d f
    c c c d e e
    c c c d e f
    c c c d f f
    c c c e e e
    c c c e e f
    c c c e f f
    c c c f f f
    c c d d d e
    c c d d d f
    c c d d e e
    c c d d e f
    c c d d f f
    c c d e e e
    c c d e e f
    c c d e f f
    c c d f f f
    c c e e e f
    c c e e f f
    c c e f f f
    c d d d e e
    c d d d e f
    c d d d f f
    c d d e e e
    c d d e e f
    c d d e f f
    c d d f f f
    c d e e e f
    c d e e f f
    c d e f f f
    c e e e f f
    c e e f f f
    d d d e e e
    d d d e e f
    d d d e f f
    d d d f f f
    d d e e e f
    d d e e f f
    d d e f f f
    d e e e f f
    d e e f f f
    e e e f f f
    Reply With QuoteRegister To Reply
  8. 09-04-2017, 02:41 PM #8
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,344

    Re: Order = maximum 3 letters per decade

    hello shg the example is of a lottery 60/6 with 6 letters
    What I need is 8 letters with 5 letters
    example aaabb
    Reply With QuoteRegister To Reply
  9. 09-04-2017, 02:56 PM #9
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Order = maximum 3 letters per decade 

    Please Login or Register  to view this content.


    Maybe 3rd time's the charm
    Last edited by shg; 09-04-2017 at 03:20 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Put letters A, B, C, D in random order
    By Hitch75 in forum Excel General
    Replies: 17
    Last Post: 08-09-2016, 02:41 PM
  2. Hello! I work for DHS and I have been using excel for over a decade...
    By dreeks505 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 11-05-2012, 03:32 PM
  3. Hello! A decade ago I could write VBA...
    By theyogabubble in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 10-02-2012, 06:55 PM
  4. How to order columns based on maximum value in each column?
    By guilhermepc in forum Excel General
    Replies: 0
    Last Post: 01-16-2012, 08:14 PM
  5. How do you put in numeric order while ignoring letters?
    By JohnnyRelentless in forum Excel General
    Replies: 2
    Last Post: 10-13-2011, 09:44 AM
  6. How do I specify maximum No. of letters in a cell?
    By evalon in forum Excel General
    Replies: 5
    Last Post: 11-15-2008, 04:13 AM
  7. maximum number of letters which can be entered in excell shell
    By Helena in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-13-2006, 06:20 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1