separate cracks without typing.

[piter]

separate cracks without typing
example
18 20 36 = yes for 6 digits without repetition
18 20 38 = not because there is a repetition of the digit 8
there can not be in the separation of the cracks, cracks with
repetition of digits including zeros
http://www.mediafire.com/file/pib5xby336jtnq7/pasta_das_trincas.xlsx

 

[Peter_SSs]

Hello, Peter, using the same code
I have, a quadruple file of 850 thousand or more
Example
02 15 26 35
That is, using the same code to remove duplicates from the quadruples

You only need to change these two lines in the code.

 a = Range("A5", Range("D" & Rows.Count).End(xlUp)).Value

s = Format(a(i, 1), "00") & "," & Format(a(i, 2), "00") & "," & Format(a(i, 3), "00") & "," & Format(a(i, 4), "00")

 

[piter]

ola PEPER, PERFECT, THANK YOU!

 

[Peter_SSs]

ola PEPER, PERFECT, THANK YOU!

You're welcome. Glad they both worked for you.