You can mark the duplicates, filter the list to display the marked
entries, and delete the visible rows.
1. Mark the duplicates. See Tagging Duplicate Entries at CPearson's Duplicate And Unique Items In Lists
http://www.cpearson.com/excel/duplicat.htm
2. Apply a filter, using Filter>AutoFilter
3. Select the visible rows
4. Choose Edit>Delete
