+ Reply to Thread
Results 1 to 10 of 10

generate strings of no more than 2 digits repeated in the formations.

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

    generate strings of no more than 2 digits repeated in the formations.

    generate strings of no more than 2 digits
    repeated in the formations,
    * will be used 10 digits from 0 to 9
    the string will have 5 digits = example
    * 1,2,5,9,3
    0,4,8,9,2 = repeated 2.9
    1.6.3.8.4 = repeated 8.4
    Another example
    1,2,5,9,3
    1,5,8,0,3 = can not be excluded because it has 3 digits
    * repeated = 1.5,3
    * the maximum limit is the repetition of two digits
    * in the context of training.
    then after the training has been generated, if you have any of it with a 3-digit repetition,
    * The maximum is 2 digits, please.

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

    Re: generate strings of no more than 2 digits repeated in the formations.

    hello please

  3. #3
    Valued Forum Contributor dmcgov's Avatar
    Join Date
    11-11-2015
    Location
    Florida, USA
    MS-Off Ver
    Office 365 Business
    Posts
    1,242

    Re: generate strings of no more than 2 digits repeated in the formations.

    maybe load up a desensitized workbook. but i'm not really sure of what you are asking for. mock up the workbook, include a BEFORE and AFTER sheets so i can make heads or tails of your solution.

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

    Re: generate strings of no more than 2 digits repeated in the formations.

    ok dmcgov please

  5. #5
    Valued Forum Contributor dmcgov's Avatar
    Join Date
    11-11-2015
    Location
    Florida, USA
    MS-Off Ver
    Office 365 Business
    Posts
    1,242

    Re: generate strings of no more than 2 digits repeated in the formations.

    do you know how to attach a workbook to your post?

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

    Re: generate strings of no more than 2 digits repeated in the formations.

    generate all strings with 5 digits
    * following criteria:
    * always from the last strigs to the next
    * the repetition of the whole of the generation can only repeat the digits twice, or once or zero
    * any strings that have three repetitions
    * is deleted, the maximum of the repetition is two replications
    https://www.excelforum.com/attachmen...1&d=1562868156
    Attached Files Attached Files

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

    Re: generate strings of no more than 2 digits repeated in the formations.

    hello, DMCGOV,please!!

  8. #8
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    7,558

    Re: generate strings of no more than 2 digits repeated in the formations.

    This proposal employs five helper columns which may be moved and/or hidden for aesthetic purposes.
    The helper columns (V:Z) are populated using: =MATCH(A4,$A3:$E3,0)
    Column is populated using: =IF(COUNT(V4:Z4)<=2,"yes","no")
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

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

    Re: generate strings of no more than 2 digits repeated in the formations.

    hello, JETE, perfect, good job, conglatulations,
    objective = was to have all possible strings of at most 2 digits repeated, to use in choosing pick3 in any state, now I can easy it
    ok jete, thank you !!

  10. #10
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    7,558

    Re: generate strings of no more than 2 digits repeated in the formations.

    You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.

+ 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