Remove or highlight duplicates

Hi all.

I have a list of 2400 records, I copied and worked on about 500 of them .. but in my infinite wisdom I failed to note them on the original sheet. So I don't want to work on records/call customers I've already worked on. What I'd like to do is compare my 500 records (Target) and remove them from the main sheet. I've tried the "Remove duplicate" function in excel, but it still leaves me with one record.

In summary, I need to remove the row in the main sheet when it finds and matches in the target sheet.

Many thanks for any help.

Try:

Please Login or Register  to view this content.

Brilliant, that's done the job. Many thanks!