If you want to remove duplicates from Col A (say upto row 1000) then enter
this in B1
=COUNTIF(A1:$A$1000,A1) and copy down till B1000

Now any cell in Col B with a number 2 or higher represent a duplicate so you
can filter on 1 and delete those rows

"BlindShelter" wrote:

I have a mailing list that is in EXCEL. Occasionally we purchase mailing
lists to solicit new clients and we want to delete the duplicates from the
new lists that are already in our database. My knowledge of EXCEL is very
rudimentary so please be gentle.