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

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

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

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

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

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

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

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