Remove duplicates does not remove all duplicates...

UPDATE: TRIM removed spaces (trailing it seems) and fixed the issue. Thanks.

Hi all,
I have done some research on this issue but I cannot find a solution. Maybe insanity is setting in after so many hours working on this project!!

I have a lengthy list of part numbers upon which I execute VBA (recorded macro) to remove duplicates. For some reason XL/VBA omits deleting a few of the duplicated parts.

I have attached the sample of part numbers if you can help me solve the mystery please... I have used tools such as this one built by "shg" and have confirmed the duplicate parts have the same values in Binary.

You will notice on Col B I set up a CountIf formula and the culprits read "2" instances in the list... and XL says n"no duplicates found" when doing a manual delete duplicates...

What am I missing? Thank you for your help!

M

CountIf = 2 , meaning there is 2 same result.

XL says n"no duplicates found"

, what is that meaning?
BTW, i can't see the macro that you mention.

Hi wenqq3,
Thanks for the reply. I did not include the macro in the attachment as the result (whether using macro or manual process) is the same, as in, some duplicated parts do not get deleted.

The macro line where is execute the "remove duplicates" is basically this:

Please Login or Register  to view this content.

I extracted the list of parts and pasted them into the sample XL file (col A) I attached. I added a "countif" column (B) to confirm whether XL is seeing these values as different or the same.

Try doing the remove duplicates on column A of the sample (via manual / ribbon way). For me the resulting parts list still contains duplicates. I confirm this by placing a filter on col A (parts) & B (countif) and selecting all cells in col B where the value is "2".

I have edited the sample to include the filters at the header rows. Pick col B and select all entries with value "2" to see the duplicates.

Does this make sense? Thanks again

M

Please Login or Register  to view this content.

i still can't get the exactly meaning. But i think you want remove the duplicate row.
Macro is no fast.
Maybe you can do the pivot table. It will only list the record without duplicate.
Then you can just copy the list and paste to other place you want.