+ Reply to Thread
Results 1 to 9 of 9

Order = maximum 3 letters per decade

Hybrid View

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

    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

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

    Re: Order = maximum 3 letters per decade

    bcccc= error= maximum 3 letters

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

    Re: Order = maximum 3 letters per decade

    please!!help

  4. #4
    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

  5. #5
    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

  6. #6
    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.

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

    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

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

    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

  9. #9
    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

    aaabb	aaccc	abbbc	abdeh	acdff	adggg	bbccc	bcccd	bdddf	bffhh	ccghh	cfffh	deggg
    aaabc	aaccd	abbbd	abdff	acdfg	adggh	bbccd	bccce	bdddg	bfggg	cchhh	cffgg	deggh
    aaabd	aacce	abbbe	abdfg	acdfh	adghh	bbcce	bcccf	bdddh	bfggh	cddde	cffgh	deghh
    aaabe	aaccf	abbbf	abdfh	acdgg	adhhh	bbccf	bcccg	bddee	bfghh	cdddf	cffhh	dehhh
    aaabf	aaccg	abbbg	abdgg	acdgh	aeeef	bbccg	bccch	bddef	bfhhh	cdddg	cfggg	dfffg
    aaabg	aacch	abbbh	abdgh	acdhh	aeeeg	bbcch	bccdd	bddeg	bgggh	cdddh	cfggh	dfffh
    aaabh	aacdd	abbcc	abdhh	aceee	aeeeh	bbcdd	bccde	bddeh	bgghh	cddee	cfghh	dffgg
    aaacc	aacde	abbcd	abeee	aceef	aeeff	bbcde	bccdf	bddff	bghhh	cddef	cfhhh	dffgh
    aaacd	aacdf	abbce	abeef	aceeg	aeefg	bbcdf	bccdg	bddfg	cccdd	cddeg	cgggh	dffhh
    aaace	aacdg	abbcf	abeeg	aceeh	aeefh	bbcdg	bccdh	bddfh	cccde	cddeh	cgghh	dfggg
    aaacf	aacdh	abbcg	abeeh	aceff	aeegg	bbcdh	bccee	bddgg	cccdf	cddff	cghhh	dfggh
    aaacg	aacee	abbch	abeff	acefg	aeegh	bbcee	bccef	bddgh	cccdg	cddfg	dddee	dfghh
    aaach	aacef	abbdd	abefg	acefh	aeehh	bbcef	bcceg	bddhh	cccdh	cddfh	dddef	dfhhh
    aaadd	aaceg	abbde	abefh	acegg	aefff	bbceg	bcceh	bdeee	cccee	cddgg	dddeg	dgggh
    aaade	aaceh	abbdf	abegg	acegh	aeffg	bbceh	bccff	bdeef	cccef	cddgh	dddeh	dgghh
    aaadf	aacff	abbdg	abegh	acehh	aeffh	bbcff	bccfg	bdeeg	ccceg	cddhh	dddff	dghhh
    aaadg	aacfg	abbdh	abehh	acfff	aefgg	bbcfg	bccfh	bdeeh	ccceh	cdeee	dddfg	eeeff
    aaadh	aacfh	abbee	abfff	acffg	aefgh	bbcfh	bccgg	bdeff	cccff	cdeef	dddfh	eeefg
    aaaee	aacgg	abbef	abffg	acffh	aefhh	bbcgg	bccgh	bdefg	cccfg	cdeeg	dddgg	eeefh
    aaaef	aacgh	abbeg	abffh	acfgg	aeggg	bbcgh	bcchh	bdefh	cccfh	cdeeh	dddgh	eeegg
    aaaeg	aachh	abbeh	abfgg	acfgh	aeggh	bbchh	bcddd	bdegg	cccgg	cdeff	dddhh	eeegh
    aaaeh	aaddd	abbff	abfgh	acfhh	aeghh	bbddd	bcdde	bdegh	cccgh	cdefg	ddeee	eeehh
    aaaff	aadde	abbfg	abfhh	acggg	aehhh	bbdde	bcddf	bdehh	ccchh	cdefh	ddeef	eefff
    aaafg	aaddf	abbfh	abggg	acggh	afffg	bbddf	bcddg	bdfff	ccddd	cdegg	ddeeg	eeffg
    aaafh	aaddg	abbgg	abggh	acghh	afffh	bbddg	bcddh	bdffg	ccdde	cdegh	ddeeh	eeffh
    aaagg	aaddh	abbgh	abghh	achhh	affgg	bbddh	bcdee	bdffh	ccddf	cdehh	ddeff	eefgg
    aaagh	aadee	abbhh	abhhh	addde	affgh	bbdee	bcdef	bdfgg	ccddg	cdfff	ddefg	eefgh
    aaahh	aadef	abccc	acccd	adddf	affhh	bbdef	bcdeg	bdfgh	ccddh	cdffg	ddefh	eefhh
    aabbb	aadeg	abccd	accce	adddg	afggg	bbdeg	bcdeh	bdfhh	ccdee	cdffh	ddegg	eeggg
    aabbc	aadeh	abcce	acccf	adddh	afggh	bbdeh	bcdff	bdggg	ccdef	cdfgg	ddegh	eeggh
    aabbd	aadff	abccf	acccg	addee	afghh	bbdff	bcdfg	bdggh	ccdeg	cdfgh	ddehh	eeghh
    aabbe	aadfg	abccg	accch	addef	afhhh	bbdfg	bcdfh	bdghh	ccdeh	cdfhh	ddfff	eehhh
    aabbf	aadfh	abcch	accdd	addeg	agggh	bbdfh	bcdgg	bdhhh	ccdff	cdggg	ddffg	efffg
    aabbg	aadgg	abcdd	accde	addeh	agghh	bbdgg	bcdgh	beeef	ccdfg	cdggh	ddffh	efffh
    aabbh	aadgh	abcde	accdf	addff	aghhh	bbdgh	bcdhh	beeeg	ccdfh	cdghh	ddfgg	effgg
    aabcc	aadhh	abcdf	accdg	addfg	bbbcc	bbdhh	bceee	beeeh	ccdgg	cdhhh	ddfgh	effgh
    aabcd	aaeee	abcdg	accdh	addfh	bbbcd	bbeee	bceef	beeff	ccdgh	ceeef	ddfhh	effhh
    aabce	aaeef	abcdh	accee	addgg	bbbce	bbeef	bceeg	beefg	ccdhh	ceeeg	ddggg	efggg
    aabcf	aaeeg	abcee	accef	addgh	bbbcf	bbeeg	bceeh	beefh	cceee	ceeeh	ddggh	efggh
    aabcg	aaeeh	abcef	acceg	addhh	bbbcg	bbeeh	bceff	beegg	cceef	ceeff	ddghh	efghh
    aabch	aaeff	abceg	acceh	adeee	bbbch	bbeff	bcefg	beegh	cceeg	ceefg	ddhhh	efhhh
    aabdd	aaefg	abceh	accff	adeef	bbbdd	bbefg	bcefh	beehh	cceeh	ceefh	deeef	egggh
    aabde	aaefh	abcff	accfg	adeeg	bbbde	bbefh	bcegg	befff	cceff	ceegg	deeeg	egghh
    aabdf	aaegg	abcfg	accfh	adeeh	bbbdf	bbegg	bcegh	beffg	ccefg	ceegh	deeeh	eghhh
    aabdg	aaegh	abcfh	accgg	adeff	bbbdg	bbegh	bcehh	beffh	ccefh	ceehh	deeff	fffgg
    aabdh	aaehh	abcgg	accgh	adefg	bbbdh	bbehh	bcfff	befgg	ccegg	cefff	deefg	fffgh
    aabee	aafff	abcgh	acchh	adefh	bbbee	bbfff	bcffg	befgh	ccegh	ceffg	deefh	fffhh
    aabef	aaffg	abchh	acddd	adegg	bbbef	bbffg	bcffh	befhh	ccehh	ceffh	deegg	ffggg
    aabeg	aaffh	abddd	acdde	adegh	bbbeg	bbffh	bcfgg	beggg	ccfff	cefgg	deegh	ffggh
    aabeh	aafgg	abdde	acddf	adehh	bbbeh	bbfgg	bcfgh	beggh	ccffg	cefgh	deehh	ffghh
    aabff	aafgh	abddf	acddg	adfff	bbbff	bbfgh	bcfhh	beghh	ccffh	cefhh	defff	ffhhh
    aabfg	aafhh	abddg	acddh	adffg	bbbfg	bbfhh	bcggg	behhh	ccfgg	ceggg	deffg	fgggh
    aabfh	aaggg	abddh	acdee	adffh	bbbfh	bbggg	bcggh	bfffg	ccfgh	ceggh	deffh	fgghh
    aabgg	aaggh	abdee	acdef	adfgg	bbbgg	bbggh	bcghh	bfffh	ccfhh	ceghh	defgg	fghhh
    aabgh	aaghh	abdef	acdeg	adfgh	bbbgh	bbghh	bchhh	bffgg	ccggg	cehhh	defgh	ggghh
    aabhh	aahhh	abdeg	acdeh	adfhh	bbbhh	bbhhh	bddde	bffgh	ccggh	cfffg	defhh	gghhh


    Maybe 3rd time's the charm
    Last edited by shg; 09-04-2017 at 03:20 PM.

+ 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. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1