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