Find and remove duplicate entries in Excel with ConnectCode Duplicate Remover
EditByBSEditor: ConnectCode Duplicate Remover is a powerful add-in for finding and removing duplicates entries in Excel. It can save you hours of time when you need to prepare an unique list from a huge list of multiple entries. With the Duplicate Remover Excel Add-in, you will be able to

1) Create a new worksheet to store the unique list (leaving the original list unchanged)
2) Hide the duplicates in the original list temporarily
3) Highlight the duplicates in a list using a different background color
4) Delete duplicates by making cells blank
5) Compare two lists and find the similarities or differences among them

The add-in installs as a toolbar within Excel and is very easy to use. Clicking the Remove Duplicates button on the toolabr will launch the main dialog that lets you select a range and quickly remove duplicates. you can free download ConnectCode Duplicate Remover 1.0 now.