identify the 3 letter pattern in the draw line

[piter]

identify the 3 letter pattern
in the draw line
http://www.mediafire.com/file/27frtcym6d6ulxx/detectar_os_padroes_das_3_letras_no_sorteio.xlsx/file

 

[Special-K99]

An full explanation is required.

 

[piter]

****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">


472/5000

​

[COLOR=rgba(0, 0, 0, 0.87)]okay okay, my lottery is 01 to 31 are drawn 7 numbers ok
we have 3 groups represented by 3 letters = abc
a = 01 02 03 04 05 06 07 08 09 10
b = 11 12 13 14 15 16 17 18 19 20
c = 21 22 23 24 25 26 27 28 29 30 31
the 27 patterns cover up to 5 numbers in a row
then the macro identifies the corresponding letter and its quantity
ex = 01 02 03 12 13 14 22 = is the same as aaabbbc
Why do we have 3 letters? because it has 01 02 03 'and group A





[COLOR=rgba(0, 0, 0, 0.87)] [/COLOR][COLOR=rgba(0, 0, 0, 0.87)]and so on the others[/COLOR]472/5000

​

[/COLOR]

​

[COLOR=rgba(0, 0, 0, 0.87)]okay okay, my lottery is 01 to 31 are drawn 7 numbers ok
we have 3 groups represented by 3 letters = abc
a = 01 02 03 04 05 06 07 08 09 10
b = 11 12 13 14 15 16 17 18 19 20
c = 21 22 23 24 25 26 27 28 29 30 31
the 27 patterns cover up to 5 numbers in a row
then the macro identifies the corresponding letter and its quantity
ex = 01 02 03 12 13 14 22 = is the same as aaabbbc
Why do we have 3 letters? because it has 01 02 03 'and group A
and so on the others



[/COLOR]
</body>
472/5000

​

​

[COLOR=rgba(0, 0, 0, 0.87)]okay okay, my lottery is 01 to 31 are drawn 7 numbers ok
we have 3 groups represented by 3 letters = abc
a = 01 02 03 04 05 06 07 08 09 10
b = 11 12 13 14 15 16 17 18 19 20
c = 21 22 23 24 25 26 27 28 29 30 31
the 27 patterns cover up to 5 numbers in a row
then the macro identifies the corresponding letter and its quantity
ex = 01 02 03 12 13 14 22 = is the same as aaabbbc
Why do we have 3 letters? because it has 01 02 03 'and group A
and so on the others



[/COLOR]

 

[Special-K99]

You're after a macro solution?

 

[Fluff]

Isn't this a duplicate of https://www.mrexcel.com/forum/excel...ate-all-formations-3-letters.html#post5234479

 

[piter]

hello fluff, the question is quite different, although both speak of letters
here it asks to identicar in each line the letters and their quantity, there it asks for the formations,
these are already on the topic of this planilia, things different things

 

[piter]

hello, please!