+ Reply to Thread
Results 1 to 9 of 9

how many formations are possible using ascending strings? *

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

    how many formations are possible using ascending strings? *

    how many formations are possible using ascending strings?
    * example is for a 31/7 lottery
    string = 00011112246678 = 14 digits
    can generate this = 01 06 08 14 17 21 26
    * ok, but could generate more, the question is
    * how many more?
    * or a string given how many formations would it have?

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

    Re: how many formations are possible using ascending strings? *

    matris 31/7
    01 02 03 04 05 06 07 08 09 10
    11 12 13 14 15 16 17 18 19 20
    21 22 23 24 25 26 27 28 29 30
    31

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    mysore
    MS-Off Ver
    Excel 2007
    Posts
    4,378

    Re: how many formations are possible using ascending strings? *

    Code for macro
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  4. #4
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,068

    Re: how many formations are possible using ascending strings? *

    213/5000
    almost there the training is from the limit of 01 to 31
    and must have 7 numbers (14 digits)
    ex = 01 06 08 14 17 21 26, or 02 04 07 12 21 26 ...
    the macro has look at the amount of digits

    to mount the 7-number string

  5. #5
    Forum Expert
    Join Date
    07-20-2011
    Location
    mysore
    MS-Off Ver
    Excel 2007
    Posts
    4,378

    Re: how many formations are possible using ascending strings? *

    Revised code
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by kvsrinivasamurthy; 02-12-2019 at 11:16 AM.

  6. #6
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,068

    Re: how many formations are possible using ascending strings? *

    the macro is not running.
    the macro always has to have
    * a reference string
    * to create the training
    ex = digit to reference string
    * 00111222677899
    above the digit 3
    * i.e., 3,4,5,6,7,8,9,0
    * are for the last digit
    * ex = 28 last digit 8

  7. #7
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,068

    Re: how many formations are possible using ascending strings? *

    I will always choose a string, base or reference over the chosen strings typed in a field
    * the macro will generate all the formations

  8. #8
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,068

    Re: how many formations are possible using ascending strings? *

    or I will type certain or chosen string in the worksheet the macro will generate all the combinations, taking the string as base

  9. #9
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,068

    Re: how many formations are possible using ascending strings? *

    matriz lottery= 31/7
    01 02 03 04 05 06 07 08 09 10
    11 12 13 14 15 16 17 18 19 20
    21 22 23 24 25 26 27 28 29 30
    31

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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