Remove duplicates from Microsoft Excel worksheets

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

Duplicate Remover for Microsoft® Excel®

For Microsoft Excel 2007, 2003, XP (2002), 2000.

With Duplicate Remover for Microsoft Excel you can easily remove duplicates from your Microsoft Excel worksheets or find unique entries. Once duplicates are found, you can easily delete select, color or copy such entries, or move them 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 can 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 of with Microsoft Excel pleasant and easy.

The Duplicate Remover for Microsoft Excel add-in will eliminate duplicates in 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.
• Check 2 tables (lists) for 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 found rows.
• Color found items.
• Copy or move found rows to another location: (new Microsoft Excel workbook, new/existing worksheet).

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

Here is a step-by-step instruction. 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 data that you will search for: duplicate entires or unique entries.

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

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

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

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

Choose what you want to do with found entries:

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

Click on the Finish button

Allow a few seconds for processing.

Enjoy the results.

Check 2 tables (lists) for duplicates or unique entries

Here is a step-by-step instruction 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, or go to Excel Menu Tools -> Duplicate Remover.

Wizard step 1 - Select the search mode

Select the "Compare two tables (lists, ranges)" mode. In "Select the first Table", enter your first table range. 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, 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 second list only), or duplicates (entries that are in both lists).

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

Select a 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 lists have headers, check the "My data has headers" checkboxes for a corresponding table.

Step 5 - Select the action with found values

Choose what you want to do with found values:

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

Click on the Finish button

Wait for couple of seconds until your data are processed.

Enjoy the results.

Duplicate Remover for Microsoft Excel is compatible with

• OS: Microsoft Windows Vista (x32, x64), Microsoft Windows 2003, Windows XP, 2000, ME, 98
• Microsoft Excel 2007, Microsoft Excel 2003, Microsoft Excel XP, Microsoft Excel 2000.

Try before you buy

Download a fully-functional 15-day evaluation version and try for yourself.