VBA to remove duplicates by group

[ChemistB]

Column A has ID numbers (always sorted alphabetically). Each ID may appear from 1 to 10 times (usually just 3 or 4).
In another column (In C for this example but can be from C to Z) are other entries that repeat randomly.

I need VBA that compares the values in "Newcolumn" to others with the same ID and removes duplicates.
By this I mean that if "oil" for example, shows up twice (or more) the 2nd (and 3rd) times the cell would be blank.
There would only be one "oil" for that ID.

I could probably do this with nested DO loops but I think that would be very time consuming especially since I am not
sure how I would alter the ranges. Is there an expedient way to accomplish this?

Please Login or Register  to view this content.

[Keebellah]

You mention that the columns can be anywhere form C-Z
and that column A will hold a sorted list of IDs
Is there any relationship between the ID and the text in either columns?
Or just take ID001 and check each column with data and if the value is duplicated clear the contents for that row and then do so for each ID?

So relish may appear in three or four columns but on a row with a different ID.

This will be macro with a loop per column but that will be quite fast.

Let me know if I understood you correctly and if this is what you are requesting?

[JieJenn]

Would this work? Just adjust the new column index.

Please Login or Register  to view this content.

[ChemistB]

@hans
I am only interested in group duplicates in a single column and clearing dups from that column only (not clearing the whole row).

JieJenn, works perfectly. I should have thought of that negative step. Thank you both.

[JieJenn]

Good thing I paid attention during class.

@hans
I am only interested in group duplicates in a single column and clearing dups from that column only (not clearing the whole row).

JieJenn, works perfectly. I should have thought of that negative step. Thank you both.