detect in each of the columns the sequence in each draw.

[jack]

detect in each of the columns the sequence in each draw, and show in a list next to the classification, descending from the largest quantity to the smallest,
objective = is to find sequences of the ones that come out the most in the draws, to see the ones that are late but the ones that come out the most
https://www.mediafire.com/file/sd4zqhkw22gl5bi/3+lista+de+sequencias.xlsx/file

 

[jack]

ex= 01 05 06 08 09=it has already been drawn 12 times, it is just an example

 

[jack]

hello please!

 

[Frank]

You are not going to get any replies because you request is impossible to understand. You talk about sequence, classification, all meaningless words without detailed explanation. As usual your spreadsheet conveys no useful information, it does not explain the process taking place. Where do the figures in the yellow, blue and green come from? What process has taken place?

 

[jack]

ok FRANK ! thanks for seeing the post, well let's go step by step with the aforementioned lottery
It's lotofacil (Brazil) 25-15 has 01 to 25 numbers 15 numbers are drawn ok
these three lists are like this
imagine the hue of the 5x5 lotofacil
5 columns and 5 rows. these two three lists
first list uses combinations of 4 to 9 of the first ten numbers that occur from 4 to 9 in 10
95% of these are in the rows, in the columns of 10
first 4 to 9 also come out in 95%
the third list is smaller because it uses all combinations
from 3 to 9 of the remaining 9 tens of the two lists,
This is just to know where it comes from, but objective
is to see how many times each of these sequences
is drawn in each line of draws, which will be updated every week with new draws,
then make a list on the side showing the sequences that are drawn most often and that are late, but only those that were drawn most often

 

[jack]

MATRIZ
01 02 03 04 05
06 07 08 09 10
11 12 13 14 15
16 17 18 19 20
21 22 23 24 25

01 02 03 04 05
06 07 08 09 10
11 12
16 17
21 22

13 14 15
18 19 20
23 24 25

 

[Frank]

I wish I’d never asked. Hopefully someone else can decipher what all this means. You still don’t explain the spreadsheet and what is going on. Im Out.

 

[jack]

hello frank, next to each sequence
the macro put
how many times it was drawn, the basis for this is the register of draws on the side,
example
02 06 09 08 10 15... was drawn xxx times