There are a couple of ways to do this.
One is using VB and a procedure to delete duplicate items.
Or you could use Data- Filter- Advanced Filter
By selecting the Select Unique Records only and copying to another range you
will get a list of non-duplicate items.

Nick


"ticephotos" wrote in message
...
I work with a list of about 3500 entries in Excel that is updated every 2
weeks. Is there any way to easily delete out duplicate entries without
manually sorting the list and deleting them one at a time?