Hello, after searching on this forum and on youtube I considered that I should post my question on how to extract the most frequent pattern formed out of 6 numbers out of a total of 1192 patterns.
For example, these are my first four patterns:
1 0 0 0 1 0
1 0 1 0 1 1
1 1 0 0 1 0
1 1 1 0 1 1
and let's say that the next pattern would have been:
1 1 0 0 1 0
For example, I would like a result that would give me: "1 1 0 0 1 0'' is the most frequent pattern. (not this pattern!)
I found on this forum this formula:
"With
A1:A15 containing your posted data
and
B1:B4 containing your posted sequence to be found
This formula returns the count of that sequence in A1:A15
"
But I do not want a certain sequence to be found, this is my problem.
Bookmarks