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

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

    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,518

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

    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,518

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

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

    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 2019
    Posts
    17,428

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

    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 2019
    Posts
    17,428

    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)

Similar Threads

  1. please, generate all possible formations using zero and the maximum 3 digits.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-09-2019, 01:36 PM
  2. [SOLVED] please, detect and separate formations * that has the digits = 0,1,2 only.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-04-2019, 10:29 AM
  3. Replies: 6
    Last Post: 09-06-2018, 09:05 AM
  4. 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
  5. [SOLVED] Remove formations with duplicate digits
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-04-2017, 12:00 PM
  6. separate formations with duplicate digits, please
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-25-2016, 05:08 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