Remove duplicates from Excel
For Microsoft Excel 2010 32-bit and 64-bit, Excel 2007, Excel 2003.
With Duplicate Remover you can remove duplicates from your Microsoft Excel worksheets or find unique entries in your tables in a breeze. Once the duplicates are found, you can delete, select, color and copy them, or move the values to another location, such as a new workbook or new / existing worksheet.
The add-in can check for duplicates in one or two Microsoft Excel 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 with Microsoft Excel pleasant and easy.
| Download Now | Feature Tour | See how it works |
Eliminating duplicate entries manually may be a real headache when you have large worksheets containing thousands of rows, and you can never be certain that you've got rid of them all. The Duplicate Remover add-in does the job promptly, quietly and perfectly - you can be sure to 100% that no unnoticed duplicates are left in your Excel lists.
You can work with the Duplicate Remover in either of the two available modes:
This is the option you use when you have just 1 Excel list to search for duplicates. All is done on one screen and literally in a few seconds: you simply select the needed columns, choose what you want to do with the found entries and click Run. That's it – enjoy the result!
For more details, please see
How to remove duplicates from one worksheet.
You use this option when you need to compare 2 lists, which can be located either in one worksheet or in two different worksheets. You can also use the Advanced Wizard on one list instead of the Quick Remover if you like it better :) A smart wizard walks you through the process, and here you are - duplicates / uniques are deleted, highlighted, colored or moved, or whatever you choose.
For more information, please see
How to find duplicates in 2 Excel tables.
Your Duplicate remover program for Excel has saved me so much time and headaches, I cannot tell you! I love it! It literally just saved me days of grueling & painstaking deletion of dupes and that was for just one project..
I can only imagine what it will save me in the long run. Oh, and thank you as well for the ability to install this on up to 3 computers with one activation, I can now enjoy the same capabilities whether I am working from home or the office. Thanks
Hunter Fitzgerald
I put it to use immediately and it is AWESOME! This little ditty saved me hours comparing the 2 worksheets that both had over 2,000 lines. I was able to find any that didn't match in about 2 seconds! Sue Covington
I just have to tell you that Duplicate Remover is the best tool I could ever have. I spend all day in Excel and Access and Duplicate Remover has increased my efficiency 100% - ok well maybe 50%. But I honestly do not know how anyone who has to constantly run pivots, graphs, data exports yadda yadda yadda all day could ever go back to living without this tool once they have used it. I actually laugh at people who tell me: "Oh I just import into Access to get rid of my duplicates". HA HA I say! Have you never heard of AbleBits Duplicate Remover? I just really wish you guys could be something that comes with Excel so a person like me would not have to go through the whole corporate purchase bureaucracy to purchase a measly $ 29.99 product that is worth every single cent! Thanks for a terrific product!
PS my favorite feature is actually the data comparing between ranges - oh what a handy little tool that is!Dianne Young
Please see the online help for detailed step-by-step instructions:
Click Like and get 15% discount on all our products right now!
You can purchase a license of Duplicate Remover for Excel online with any major credit cards, bank wire transfer, check, PayPal or order by fax.
You can buy this add-in as part of the AbleBits Add-in Collection for Excel (11 add-ins in 1 package) and save 60% off.
Quantity | USD | EUR | GBP | Volume discount |
1 | 29.95 | 19.95 | 19.95 | |
2-4 | 28.45 | 18.95 | 18.95 | 5% |
5-9 | 26.95 | 17.96 | 17.96 | 10% |
10-24 | 23.95 | 15.96 | 15.96 | 20% |
25-49 | 20.95 | 13.97 | 13.97 | 30% |
50 & more | ||||
If you are not happy with our product for any reason,
you will get your money back, no questions asked.
Copyright © 2003 - 2012 Add-in Express Ltd. All rights reserved.
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
