Find and remove duplicate or unique values in Excel

Duplicate Remover for Microsoft Excel 2013-2003

Task

You want to be sure that your large Excel databases are duplicate-free. You have about ten minutes before you pass the spreadsheets to your customer.

Solution

Duplicate Remover for Microsoft Excel lets you find duplicate and unique entries in your workbooks in 5 easy steps. You can process spreadsheets with up to one million rows and highlight or remove duplicate entries. Besides, you can choose to color duplicates or unique values, copy them to a separate worksheet or mark as unique or duplicate in the status column.

Find duplicates in Excel: delete, mark, copy, or move them.

Duplicate Remover key features

Quick Remover mode.
  • Find duplicate or unique entries in Excel worsksheets
  • Work in two modes – Quick Remover and Advanced Wizard
  • Search for duplicates or uniques in 1 table
  • Find duplicates or unique occurrences in 2 tables
  • Select columns to be searched for duplicates or uniques
  • Effectively handle spreadsheets with thousands of rows
  • Select or highlight duplicate rows or unique entries
  • Copy the found entries to another worksheet
  • Delete duplicate entries from the Excel book or move them to another location
  • Add a status column which marks uniques and duplicates

Tip

You can get this add-in as a part of Ultimate Suite for Excel - 20+ add-ins destined to cut your time and clicks on the most frequent spreadsheet tasks.

How Duplicate Remover for Excel works

Search for duplicates in 1 Excel sheet.
Compare two Excel tables for duplicates or uniques.
Select the columns to be compared.
Compare the tables from different spreadsheets.
Mark the values as unique or duplicate in the status column.

Excel tables are often used as databases containing sales or customers records, mailing lists and inventories. The bigger such databases become, the more evident seems the problem of duplicate values. When the steps you need to take with the standard Excel functions appear overkill, it is nice to get something easier-to-use and more advanced. Something like Duplicate Remover for Microsoft Excel, which is really helpful in removing duplicate entries or finding unique values in your spreadsheets.

Launched at a click, the add-in offers you to choose between two tools: Quick Remover or Advanced Wizard. It's all about your time and effectiveness. Choose the Quick Remover mode if you need to swiftly get rid of duplicate entries located in one table. Advanced Wizard can do it all but it is especially good at comparing two spreadsheets. It will kindly guide you through the process showing the steps you are on.

With this irreplaceable software you can easily define the type of data you want to find and select the columns to be searched for duplicates or uniques. In addition, it is possible to ignore headers, extra spaces or empty cells. All the found duplicates can be removed, selected or highlighted, colored or copied to a new destination. Besides, the plug-in will create a new column in your table identifying whether an entry is duplicate or unique, if necessary.

Find duplicates or unique entries in Excel

Duplicate Remover for Excel can search for duplicate or unique records in your workbooks, Excel lists, or the selected range. It can also find duplicates and uniques with or without their first occurrences in the spreadsheets.

Work in two modes – Quick Remover and Advanced Wizard

If you often work with really large or not so large single tables that contain duplicate values, you may need a fast tool to get rid of them quickly. As easy as that you can just run the one-window Quick Remover, tweak the necessary options and voila, you have all the found entries at a glance.

One more option is using the step-by-step Advanced Wizard. It allows you to adjust the search process, look for duplicate or unique values in one or two tables as well as select some handy post-processing features.

Search for duplicates or uniques in 1 table

If you need to check 1 table for duplicates, the easiest and quickest way is to use Quick Remover. All is done on 1 screen and in 1 step: select the needed columns, choose the action for the found dupes and click Run.

If you want to find unique occurrences, use the Advanced Wizard. Naturally, it finds duplicates equally well and if you prefer a step-by-step wizard, you can always use it.

Find duplicates or unique occurrences in 2 tables

The Duplicate Remover add-in faultlessly finds duplicates in 2 Excel tables located in the same or in two separate worksheets with different number of columns. You can either match the entire tables or look for duplicate or unique items in the selected columns.

Select columns to be searched for dupes or uniques

Duplicate Remover for Excel lets you manually select the appropriate columns within one or two tables to be searched for unique or duplicate rows. So you will get precise results in a few clicks without processing the entire tables.

Compare the tables you select in different spreadsheets

If you have two similar tables in different workbooks you can easily compare them using this Excel add-in. It gives you the possibility to either match the entire tables or choose to look for duplicate or unique items in the selected key columns.

Effectively handle spreadsheets with thousands of rows

This Excel add-in can process even huge one-million-row tables accurately finding dupes and uniques in them.

Remove duplicate entries from Excel book or move them to another location

This add-in will dedupe your worksheets by removing all the rows with the found duplicates.

If you don't want to completely eliminate the dupes, benefit from the possibility to move the found results to a new Microsoft Excel workbook or an existing worksheet.

Add a status column which marks uniques and duplicates

When you need to know if a certain row contains a unique or duplicate value and would like to keep this information, select the Add a status column option. Thus you will not lose the selection even if you sort the rows or change the formatting in your table.

Select or highlight duplicate rows or unique entries

For the better view of the found unique or duplicate values, this Excel extension can select them or mark with the color you choose.

Copy the found uniques or duplicates to another location

Both found dupes and uniques can be copied to another workbook, worksheet or any place in the current table.

29.95
Buy now

Duplicate Remover for Microsoft Excel system requirements

Operating System

  • Windows 8 (32 and 64-bit)
  • Windows 7 (32 and 64-bit)
  • Windows Vista (32 and 64-bit)
  • Windows XP (32-bit)
  • Windows Server 2003, 2008, 2012
  • .NET Framework must be installed.

Microsoft Excel

  • Microsoft Excel 2013 (32 and 64-bit)
  • Microsoft Excel 2010 (32 and 64-bit)
  • Microsoft Excel 2007
  • Microsoft Excel 2003

Duplicate Remover for Excel version

Current add-in version: 3.0.4
published on: Feb 27, 2013

Order Duplicate Remover for Excel

29.95
Buy now
 
Contact us