VBA Remove Duplicates Not Working

[dache416]

Hello,

I need help regarding removing duplicates.

The VBA, I am using is working just find:

Please Login or Register  to view this content.

Except for this duplicates:

"FD0570 RUN DATE: 04/02/20, RUN TIME: 110855 PAGE: 1"

Would anyone please tell what better way to remove these type of duplicates?

Thank you very much,

Cheryl

[alansidman]

Here is code I have used for several years.

Please Login or Register  to view this content.

[dache416]

Hi Alan,

Your VBA is working just like the VBA I am using however it did not removed those duplicates that has part number ""FD0570 RUN DATE: 04/02/20, RUN TIME: 110855 PAGE: 1". The number change from 1 to 2, so on and so forth.

[alansidman]

I am guessing that they are not exact duplicates. There is probably some spacing issues, ie. hidden character, extra spaces. To test this theory.

In an adjacent column type =Len(cell address) where the cell address is like A4 or B5. See if the length of each is the same.

[dache416]

The length is the same. The only thing that change is the number as:

FD0570 RUN DATE: 04/02/20, RUN TIME: 110855 PAGE: 1
FD0570 RUN DATE: 04/02/20, RUN TIME: 110855 PAGE: 2
FD0570 RUN DATE: 04/02/20, RUN TIME: 110855 PAGE: 3...so on

[alansidman]

Am I missing something? What you are showing in post 5 are not duplicates. If those in Post 5 are to be deleted then you will need to split the column after PAGE: and then run your code.

[dache416]

Hi Alan - Thank you very much for your help. I found another solution to my problem. I indeed up using a VBA that delete rows with certain text.

[mjr veverka]

... what better way to remove these type of duplicates? ...

? Dictionary ?