Remove duplicates from Microsoft® Excel® worksheets

Find and delete duplicates with Duplicate Remover for Microsoft® Excel®

Duplicate Remover for Microsoft® Excel®

For Microsoft Excel 2010 32-bit, Excel 2007, Excel 2003, Excel XP (2002), Excel 2000.

With Duplicate Remover for Microsoft Excel you can easily remove duplicates from your Microsoft Excel worksheets or find unique entries in your tables. Once the duplicates are found, you can delete, select, color or copy them, or move the values to another location (new workbook, new / existing worksheet).

The add-in can check for duplicates in one or two Microsoft Excel lists or tables with up to 1 million rows. You choose any columns for comparison and compare 2 lists with different number of columns. The intuitive and user-friendly interface of the add-in helps you browse lists that you want to check for duplicates and makes your work with Microsoft Excel pleasant and easy.

With the Duplicate Remover for Microsoft Excel add-in you can dedupe your worksheets in no time. The Microsoft Excel 2007 Ribbon interface is completely supported.

With Duplicate Remover for Microsoft Excel you can

• Search in a single Microsoft Excel list (table, range) for duplicates or unique values.
• Compare 2 tables (lists) to find duplicates or unique entries.
• Process lists with up to one million rows (in Microsoft Excel 2007).
• Choose columns to be checked for duplicates.
• Search in 2 lists with different number of columns.

After duplicates or unique data are found you can

• Delete duplicate rows.
• Select the found rows.
• Color color found items.
• Copy or move the found rows to another location: new Microsoft Excel workbook, new / existing worksheet.

Duplicate Remover for Excel: Search in a single table (list)

Here are step-by-step instructions. Please click on a screenshot to enlarge.

Open the Duplicate Remover for Excel wizard by clicking on its icon or pressing Ctrl+Shift+R hotkey.

Wizard step 1 - Select the search mode

Select the "Search in a single table" mode and enter your list reference for search. Clicking on the browse button opens the standard Excel dialog for selecting a range.

Tip: Before calling the Duplicate Remover for Microsoft Excel, select any cell from your list (table / range). The wizard will automatically set the range of your list.

Step 2 - Choose the type of data you want to find

Choose the data that you will search for: duplicate entries or unique entries.

Step 3 - Select columns to be searched for duplicates or uniques.

Tick the columns that will be checked for duplicates or uniques. All columns are selected by default. If your columns have headers, select the "My table has headers" checkbox.

Tip: If you have a lot of columns and you want to search just in some of them, click on the "Uncheck all" button and then select the needed columns manually.

Step 4 - Select the action for the found duplicates (uniques)

Choose what you want to do with the found entries:

• Select the found values.
• Color rows of duplicates or unique values.
• Add a status column.
• Copy or move duplicates to another location (a new workbook, new / existing worksheet).
• Delete the values.

Click on the Finish button

Allow a few seconds for processing.

Enjoy the results.

Compare 2 tables (lists) to find duplicates or unique entries

Here are step-by-step instructions on how to search for duplicates and unique entries in two Microsoft Excel lists / tables / ranges. Please click on a screenshot to enlarge.

Open the Duplicate Remover for Excel wizard by clicking on its icon , or pressing Ctrl+Shift+R hotkey.

Wizard step 1 - Select the search mode

Select the "Compare two tables (lists, ranges)" mode. In "Select Table 1" field, enter your first table range (the one, in which you need to find duplicate or unique entries). Clicking on the browse button opens the standard Excel dialog for selecting the range.

Tip: Before calling the Duplicate Remover, select any cell from your table. The wizard will automatically set the range of your list.

Step 2 - Select the second table

First select the Microsoft Excel workbook and the worksheet with your second table, and then enter your second table range in the same way as in step 1.

Tip: You can just select / enter one cell in the table. The wizard will automatically set the range of your second table (list).

Step 3 - Choose the type of data you want to find: duplicates/uniques

Choose the type of data that you will search for: uniques (entries that are in the first or in the second list only), or duplicates (entries that are present in both lists).

Step 4 - Select pairs of columns to be checked for duplicates or uniques.

Select the column(s) from the first table and a matching column(s) from the second table that will be checked for duplicates / unique data.

If the columns in your first or second list have headers, select the "My table has headers" checkbox for the corresponding table.

Step 5 - Select the action for the found values

Choose what you want to do with the found values:

• Select the found values.
• Color rows of duplicates or unique values.
• Copy or move duplicates to another location (a new workbook, new / existing worksheet).
• Delete the found duplicates / uniques.

Click on the Finish button

Wait for a couple of seconds until your data are processed.

Enjoy the results.

Duplicate Remover for Excel is compatible with

• Operating System: Microsoft Windows 7 (x86, x64), Windows Vista (x86, x64), Windows 2003, Windows XP.
• Microsoft Office Excel 2010 32-bit, Excel 2007, Excel 2003, Excel XP (2002), Excel 2000.

Try before you buy

Download a fully-functional 15-day evaluation version of Duplicate Remover for Excel and try for yourself.