convert each number using the mirror table.

[jorel]

convert each number using the mirror table and then see if it repeats
these numbers from the last to the next draw
mirror table
01234
56789
https://www.excelforum.com/attachmen...1&d=1626868941

[queuesef]

it would be better if the data was in TEXT; and not a custom format. Then I used formula if number <6, then Add 5 Else Subtract 5. See the example attached.
I'm not sure what you mean by See if table repeats.

Bueno suerte! Tienes mitad de los resultados.

[jorel]

hello QUEUSEF, perfect, very good work, the lottery has 100 numbers and 20 are drawn and 50 numbers can be played (lotomania brazil), the repetition part is missing ie after converting mirrors into number, see if there are always repetitions of the last draw for the next, objective is to use as filters these numbers mirror of the draw
capichi

[queuesef]

si, divertido! aprendo espanol via DUOLINGO....Han pasado más de 40 años desde que estudié español. (I know more Spanish than Italian Hehe)
You may want to check out conditional formatting to assist in finding duplicates?

[jorel]

hello queuesef !!yes, can you told me the correct steps to do conditional training, thank you, there is spanish,! type in google andes mountain ranges, 7 falls, amazon to see