Handy plugin to find & remove duplicates from Excel. You can select, color, copy, or delete duplicate data or unique entries and compare two Excel lists with different number of columns..

Duplicate Remover for Excel is an add-in for Microsoft Excel 2007, Excel 2003, Excel XP (2002), and Excel 2000.

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
You can find Excel duplicates in one range or compare two Excel lists with different number of columns for duplicate rows or unique entries.

The Duplicate Remover for Microsoft Excel works with Excel 2007 and can easily handle up to 1 million rows.

Once all duplicates or uniques are found you can delete, select or color the found items, copy or move duplicates or unique records to another location: (new workbook, new/existing worksheet).

Find & remove duplicates from one 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.

1. Check the columns that will be used for comparison
2. Select the "Search in a single range" mode
3. Choose the type of data you want to find: duplicate or uniques
4. Enjoy the results.
5. Select the action with found values: delete, select, move, etc.
6. Click on the Finish button

Compare two Excel lists for duplicates: 6 easy steps
Open the Duplicate Remover for Excel wizard by clicking on its icon or pressing Ctrl+Shift+R hotkey.

1. Choose the type of data you want to find: duplicates / uniques
2. Select the "compare two ranges" mode.
3. Select second range for comparison
4. Click on the Finish button and Enjoy the results.
5. Check the columns that will be used for comparison.
6. Select the action with found values: Delete, select, color...

You can download a 30-day fully-functional trial version to test if it will suit your needs.

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