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.