Home > Excel Business Solutions > Excel Productivity > Time Saving > Duplication Management Share

Duplication Management

Excel duplication management for time saving


Excel Duplication Management

Rate this solution:
(3.5/5 from 2 votes)
Duplication Management screenshot
The Duplication Management Add-in for Excel allows to find, delete and highlight duplicates in Excel spreadsheet ranges and lists. This very handy add-in makes management of lists and duplicate data in Excel simple and efficient. It is designed to assist when there are duplicates in 1 or more lists and/or tables.

Key features and options of the Duplication Management Add-in for Excel include:
  • Create a list of unique data - an option called 'Create Unique List' that creates a fresh copy of your list on a new Worksheet that only contains one occurrence of each entry.
  • Hide all duplicates and Display only unique data - an option called 'Display Only Unique' hides all duplicates in your list showing only one occurrence of each entry.
  • Create a summary report - an option 'Summary Report' takes a list and creates a mini Pivot Table report. This shows at a glance how many times each entry in the list occurs and a total count of one occurrence of each entry. The Pivot table created can then be used to hide/show specified entries in the list.
  • Color code all duplicates, up to 3 levels - an option 'Highlight Duplicates' color codes all entries, appearing more than once, in a list of table of data. If an entry occurs twice it will have a Green background, if it appears three times it will have a Yellow background. Any entry occurring more than three times will have a Red background. The table or list range will also be dynamic in that, if you add more entries and that entry then appears 2, 3 or more times, it will be color coded accordingly.
  • Prevent users from adding duplicates to a list or table - an option 'Prevent Further Duplicates' will prevent the entering of entries that already exists in the table or list. When trying to add an entry that occurs already, a pop-up message is shown indicating that the entry already exists.
  • Compare 2 lists for matching entries - an option 'Compare Two Lists' creates a mini Pivot Table report. This will show a glance how many times each entry in each list occurs and a total count of one occurrence of each entry. The Pivot table created can then be used to hide/show specified entries in the list.
  • Remove duplicates from any range - an option 'Create a list of unique data' removes duplications from a single column list. However, there are times when there are duplications in a range, or table, that consists of more than one column. The option 'Remove Duplicates' will remove duplicates in any specified range.
  • Remove entries from one list that exist in the other - an option 'Compare 2 lists for matching entries' is ideal for showing which items appear in both lists, but does not remove them. The option Remove Entries from 'List Range' that Occur in 'List 2 Range' will accomplish the removal of such duplicates. As it creates a copy, the original 2 lists are left unchanged should they be needed.
  • Remove duplicate rows from a table - an option 'Create Unique Table' will remove all these duplicated rows from a table with duplicated rows and create a copy of your table where all rows are unique.
  • Remove all but first occurrence of duplicates - this option is useful for a table of data where some entries in a particular column have been repeated several times. Repeated entries can be removed leaving only the first occurrence.

The Duplication Management Add-in for Excel is also available in the following discounted bundled offers:

Get It

Price: USD 29.95
(Updated on 2012-09-21)

Related Excel Solutions for Duplication Management

Formula ManagementTime Saving  Data ManipulationData Management  Productivity Add-insTime Saving  Text ManipulationTime Saving  Text ManagementData Management  Find Similar DataNavigation and Auditing  Data CleansingData Management  Fuzzy MatchingData Management  Duplicate Checking and RemovalTime Saving

Share your thoughts and opinion with other users: Create Review

Browse Main Excel Solution Categories

Business Finance Financial Markets Operations Management Excel Productivity

Additional Excel business solutions are categorized as and the . Further solutions proposed for specific user requirements can be either found in the Excel Help Forum or proposed as a project to the Excel freelance community.