+ 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 2016
    Posts
    2,174

    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 2016
    Posts
    2,174

    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, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,577

    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 2016
    Posts
    2,174

    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, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,577

    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 2016
    Posts
    2,174

    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 2016
    Posts
    2,174

    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 2016
    Posts
    2,174

    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 2016
    Posts
    2,174

    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)

Similar Threads

  1. Replies: 7
    Last Post: 02-07-2019, 08:18 PM
  2. add the quantity of each digit and put the strings in ascending order.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-30-2019, 08:36 AM
  3. Generate all possible formations using strings 0 to 3 whose sum is 14 .
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-13-2018, 09:21 AM
  4. Replies: 14
    Last Post: 08-12-2017, 11:11 PM
  5. [SOLVED] Separate strings of ascending order of 4 and 5 digits
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-14-2017, 10:13 PM
  6. 15 formations ( e) x (0)
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-30-2015, 12:45 PM
  7. Formations of 6 digits in ascending order
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-28-2014, 02:11 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