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.