isolate the last digit of each number
and then detect the corresponding number in each sector
in the biggest, smallest and equal is always from the last draw to the next:anjo:

Attached Files

7 padroes em cada posiçao.xlsx (132.2 KB, 10 views)

Sorry but i have no idea what you want after the last digot of each number?

The first pasrt is easy - =RIGHT(A10,1) then drag accross and down. but what does the rest mean? and in what context?

Purfleet

ok purfleet thanks for viewing the post
let's go to the 2nd part = then we have 15 positions
one position of each last digit, we have 3 sectors or patterns, each position corresponds to a last digit
the macro must detect which pattern of the 3 sectors is represented by 7 numbers, purfleet attention is always from the last draw to the next
the reference or base is always the last draw, because I keep updating new ones every week,
in the major, minor and equal patterns
the same is when you repeat the same digit,
objective is to have sequences for filters of the 3 patterns, please

Attached Files

7 padroes em cada posiçao.xlsx (132.5 KB, 9 views)