Need Help with Deleting Duplicates

[Alan S]

I have a client that uses excel to manage their email addresses. When they
send out their newsletters they have an opt out option for people that
decide that they don't want the newsletter anymore. This opt out option
sends my client an email with the address to be removed. Is there a way to
copy the removal list into the list of all the addreses and then completely
delete the duplicate entries so the email addresses are removed from the
list? Thank You!

 

[Debra Dalgleish]

Chip Pearson has instructions for tagging duplicate entries in a list:

http://www.cpearson.com/excel/duplicat.htm#TaggingDuplicates

After you've tagged them, use an AutoFilter (Data>Filter>AutoFilter) to
select the tagged rows, and delete them.