ConnectCode Duplicate Remover1.0

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 ListThis 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 UniquesThis function lets you select a range and filter/hide the duplicates in the list.? Summary ReportThis function will create a pivot table that list the unique items in the selection and provide a count for the items.? Highlight DuplicatesThis function lets you select a range and mark duplicated rows with colors.? Prevent Further DuplicatesThis 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 ListsThis function compares two lists and places the result of the comparison in a new worksheet.? Remove DuplicatesThis function lets you select a range and remove the duplicates in the list. The duplicated values will be set to blank.? Create Unique TableThis 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 BetweenThis 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 BetweenThis 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 2007Limitations:? 50 rows limit