Deleting duplicate data - inc original cell

Hi,

I have some data (addresses atc) in excel, which i want to remove duplicates from. And also remove the original cell.

Reason being is that i have two tables one with all my contacts (table 1), and another with only a few of the samecontacts (table 2). I want to remove all the contacts from table 1 that are in table 2.

Cheers

Oh and i have looked at the Advanced filters... but u cant delete the duplicate and the original..