ConnectCode Duplicate Remover 1.0

ConnectCode Duplicate Remover 1.0 is the ideal solution to deal with 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.

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.

Functions:

• create a new worksheet to store the unique list (leaving the original list unchanged)
• hide the duplicates in the original list temporarily
• highlight the duplicates in a list using a different background color
• delete duplicates by making cells blank
• compare two lists and find the similarities or differences among them

Major Features:

1. 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.
2. Display Only Uniques: This function lets you select a range and filter/hide the duplicates in the list.
3. Summary Report: This function will create a pivot table that list the unique items in the selection and provide a count for the items.
4. Highlight Duplicates: This function lets you select a range and mark duplicated rows with colors.
5. 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.
6. Compare Two Lists: This function compares two lists and places the result of the comparison in a new worksheet.
7. Remove Duplicates: This function lets you select a range and remove the duplicates in the list. The duplicated values will be set to blank.
8. 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.
9. 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.
10. Fill Blanks Between: This function will fill the blank cells in a list with the values of an earlier entry.
11. Remove entries from "List Range" that are in "List 2 Range": This function will find the difference between 2 lists and place the result in a new worksheet called "DuplicateRemoverCompare". If an existing worksheet is already named "DuplicateRemoverCompare", it will be replaced.
    

Requirements:

• Microsoft Windows 2000 ,Win XP and 2003, Vista
• 300 MHz processor
• 64 MB RAM
• 5 MB of Hard Disk space
• Excel 2002 or Excel 2003 or Excel 2007