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:
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