Find duplicates in Excel: delete, mark, copy, move

Duplicate Remover for Microsoft Excel

Handy plugin to find and remove duplicates in Excel spreadsheets. The Duplicate Remover add-in searches within 1 list or compares 2 Excel tables with different number of columns equally well. After duplicates or uniques are found, you can select, delete and color them, copy or move found entries to another location..

Duplicate Remover for Excel is an add-in for Microsoft Excel 2010 (32-bit and 64-bit), Excel 2007, Excel 2003, Excel XP, and Excel 2000.

15-days fully-functional trial version

9.6 MB

Duplicate Remover for Excel in detail

The Duplicate Remover for Microsoft Excel will help you quickly and easily find duplicates or unique records in Excel lists or tables and remove them.

Remove duplicates in Excel

Using this add-in you can find duplicates / uniques in 1 list or search in 2 different tables by comparing any number of matching columns. The Duplicate Remover add-in can easily handle up to 1 million rows.

Once the duplicates or unique entries are found, you can delete, select or color them, copy or move found entries to another location: new workbook, new or existing worksheet.

The step-by-step wizard of the Duplicate Remover add-in will accurately walk you through the search process. Or, you can use Quick Remover for a quick search within 1 table.

Find & remove duplicates from 2 Excel list: 5 easy steps

Click on the Duplicate Remover for Excel icon or press Ctrl+Shift+R hotkey to open the Duplicate Remover for Excel wizard.

3. Choose the columns to be searched for duplicates

1. Select the "Search in a single table" mode

2. Specify the data type you are looking for: duplicate or uniques

6. Enjoy the results.

4. Select the action for found values: delete, select, move, etc.

5. Click on the Finish button

Search 2 Excel tables for duplicates: 6 easy steps

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

Define what values you want to find: duplicates or uniques

Select the "Compare two tables" mode.

Select the second table for comparison

Click on the Finish button and Enjoy the results.

3. Select matching columns for comparison.

4. Choose the action for found values: Delete, select, color etc.

Duplicate Remover for Microsoft Excel works with:

• Operating System: Microsoft Windows 7 (32-bit and 64-bit), Windows Vista (32-bit and 64-bit), Windows 2003, XP, 2000.
• Microsoft Excel 2010 (32-bit and 64-bit), Excel 2007, Excel 2003, Excel XP, and Excel 2000.

Download Duplicate Remover for Excel

• 15-days fully-functional trial version (9.6 MB)

See also in "Excel - Find and remove duplicates in Excel "

• Duplicates Manager for Microsoft Excel - Deleting duplicates in Excel, removing duplicated rows.
• Fuzzy Duplicate Finder for Microsoft Excel - Finding & correcting fuzzy duplicates and typos in Excel.