removes duplicates digit

[jack]

hello, I need a macro to remove double digits with repeated
* example
12,35 = ok, can
* 01, 41 = Can not delete because zero and the digit 1 repeated
* the list have to let peers hows 4 distinct digits, can someone help.
* lists
* will double till 1670, excel 2010 at seven

 

[Icewynd]

hello, I need a macro to remove double digits with repeated
* example
12,35 = ok, can
* 01, 41 = Can not delete because zero and the digit 1 repeated
* the list have to let peers hows 4 distinct digits, can someone help.
* lists
* will double till 1670, excel 2010 at seven

Hi Jack,

Not quite sure what you are after -- do you want to eliminate any number that does not have a specific digit (example: 2)? Or do you want to eliminate any number that does not have a specific digit in a certain position (example: 3 only if it is the last digit)?

Do you want to do the elimination for a list, or by pairs as in your example?

 

[jack]

Hello, ice, thanks for see the post, it is so. Do 01-58 pairs
*Gave a list of 1653 pairs, only along these pairs
*Are couples with repeated digits example
*01,20 ..... 12 32
*And it pairs without repetition of digits = ex = 12.38 .. no repetition of digits
These double that must separate the list are 4 digits (dig and the last number) = distinct = 1,2,3,8 are. Should give a 800duplas without repetition of digits
*Another example of this can = 01.23
15.56 = can not. Delete digtio has 5 repeated, delete, have to use this filter because in 88% giving this pattern of such double