detect only formations that have two pairs.

[jorel]

detect only formations that have
two pairs of twins no matter the position
ex = 2994116 = 99 11
formations that do not have two doubles ignore
https://www.excelforum.com/attachmen...1&d=1603896366

[jorel]

what's the doubt? the macro has to separate from the file only formations that have two digits repeated in which position,
ex = 2991446, we have two repeated digits 6 and 4
only these kind of training separate

[AliGW]

what's the doubt?

I doubt there is any, but the number of people willing to help you is getting smaller and smaller, for the reasons we've discussed before. I will say no more, but if you are never going to bother learning, then people will, eventually, lose patience with you.

[jorel]

what is intended is the pattern, of two repeated digits, ex = 44 88 66 11 etc, if people want
help I see no problem, thank you

[Kaper]

Both ex = 2994116 = 99 11
and 44 88 66 11
are impossible in your data, as the numbers in workseet (see your request from the generating them: https://www.excelforum.com/excel-pro...-0-to-9-a.html ) are in ascending order.
Moreover 44 88 66 11 is 8 digits while data is for 7 digits only.

[jorel]

hello kaper, in 10 drawings, 9 of them
has the formation of the repetition of two digits, for this reason to separate from the whole which is the 11 thousand
I have a question if I have the training 2677899
in the crescent, unfolding how many formations will we have? I know that in pick4 there are 24 possibilities
but in pick7?

[Kaper]

In H7 formula:

Please Login or Register  to view this content.

copy down and filter or sort on this column

With 3 pairs - 840 results,

2 pairs 2880 - your main question is answered here

1 pair 4590

No pairs: (but triples ar ok as well as all digits the same or all different): 3130

[jorel]

ok correct conglatulations, thank you!