Remove duplicates macro

[wonderd]

Hello everyone, I am looking for a macro that can scan column A, about 50k rows, and remove any rows that have repeat text. For example if A1 and B1 both have the word "two" then BOTH A1 and B1 rows would be deleted.

[millz]

Try running this:

Please Login or Register  to view this content.

It makes use of column B as a helper column, so make sure it is empty (unused).

[wonderd]

actually I have info in column B and C

[millz]

Then use column D as helper:

Please Login or Register  to view this content.

The red number indicates the column number, 1 = "A", 2 = "B", 4 = "D", etc.