ConnectCode Duplicate Remover

ConnectCode Duplicate Remover is a powerful add-in for finding and removing duplicates entries in Excel.
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.
This sfotware will save you lots of time when you need to prepare a unique list from a huge list of multiple entries.
Here are some key features of "ConnectCode Duplicate Remover":
ï¿­ Create Unique List
This function lets you select a range, remove the duplicates and creates an unique list of data in a new worksheet named "DuplicateRemoverSheet". If an existing worksheet is already named "DuplicateRemoverSheet", it will be replaced.
ï¿­ Display Only Uniques
This function lets you select a range and filter/hide the duplicates in the list.
ï¿­ Summary Report
This function will create a pivot table that list the unique items in the selection and provide a count for the items.
ï¿­ Highlight Duplicates
This function lets you select a range and mark duplicated rows with colors.
ï¿­ Prevent Further Duplicates
This function will apply Data Validation to the selected range so that a new duplicate entry will prompt Excel to produce an error message.
ï¿­ Compare Two Lists
This function compares two lists and places the result of the comparison in a new worksheet.
ï¿­ Remove Duplicates
This function lets you select a range and remove the duplicates in the list. The duplicated values will be set to blank.
ï¿­ Create Unique Table
This function will find the unique rows in a multiple-column table and place them in a new worksheet. The original worksheet is left unmodified. Two rows are considered different if any single column differs in value.
ï¿­ Create Blanks Between
This function will consider a value to be duplicated only if the row that precedes it also contain the same value. The duplicated values will be set to blank.
ï¿­ Fill Blanks Between
This function will fill the blank cells in a list with the values of an earlier entry.
Requirements:
ï¿­ 300 MHz processor
ï¿­ 64 MB RAM
ï¿­ 5 MB of Hard Disk space
ï¿­ Excel 2003 or Excel 2007
Limitations:
ï¿­ 50 rows limit