Rather than using Advanced Filter in order to filter a data set for unique
values, I want to delete all duplicate data.

For example, I have a spreadsheet of email addresses. I have another list of
those addresses from the original, master list that no longer work. I have
merged the two lists so that those non-working e-mail addresses now show as
duplicates. How can I remove those addresses from the master list?