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 2017-09-21)

Related Excel Solutions for Duplication Management

Data ManipulationData Management  Text ManagementData Management  Data CleansingData Management  Fuzzy MatchingData Management  Find Similar DataNavigation and Auditing  Formula ManagementTime Saving  Productivity Add-insTime Saving  Text ManipulationTime Saving  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.