Hi there and thanks in advance for any help.

How do you delete entire rows based on duplicates in certain columns? I want to search for duplicates in column C and D and then delete entire rows where this occurs. Example, in the sheet below I want to delete row number 4. Obviously we are talking about sheets where there are thousands of rows. Need a quick way to either isolate or auto delete these rows please.

Capture01.PNG