Duplicate Finder & Deleter

An add-in product for Microsoft Excel

Download a trial version now!
  • Easily find and delete duplicates in a list or between two lists
  • First color rows before deleting so you can confirm what will be deleted
  • Extremely fast
  • Find entries in one list that are not in another
  • Easy to learn with the help and exercise file

The Duplicate Finder & Deleter add-in for Microsoft Excel can quickly and easily find and delete duplicates based on entries in multiple cells.

Michael Fisher wrote regarding the Duplicate Finder & Deleter: “It was very good speaking with you this afternoon. I certainly appreciate your understanding about my system having crashed earlier and appreciate your consideration in posting me a web link for a subsequent download. I just downloaded the application and will immediately install it. If you would like a testimonial, consider this: Duplicate Finder & Deleter is an essential add-in for anyone working with large data sets, especially those assembled by mortals. Thank you again Michael”

The Duplicate Finder & Deleter can easily handle over hundreds of thousands of rows. It is completely menu-driven and very fast. The Duplicate Finder & Deleter is feature rich and easy to use.

Duplicate Finder dialog — Tab #1, single list options
Tab 1: Search a single list. Click to enlarge
Duplicate Finder dialog — compare two lists
Tab 2: Compare two lists. Click to enlarge.
Duplicate Finder dialog — Tab #3, extra options
Tab 3: Other options. Click to enlarge.

The pictures above show the Duplicate Finder's main dialog and its options.

The options on the first tab are for one list where you want to find or delete duplicates in a list.

The second tab options are for comparing two lists. You can use it to find rows in one list that are in another list or to find rows in one list that are not in another list.

The third tab:

  • Colors rows when cell entries change
  • Extracts unique values from a list
  • Selects and colors the duplicates in a block of cells (ex: A1:G25)
  • Blank duplicates entries in a selection

Our preferred approach is to first use the Duplicate Finder and Deleter to first search and find duplicates so we can confirm they are the duplicates we want to delete. Then run a second time to delete the duplicates.

More Customer Testimonials

Anji Taylor wrote regarding the Duplicate Finder & Deleter: “Yesterday I purchased your de-dupe product and wanted to let you know that it worked brilliantly to save me a ton of time on a deadline. You might be interested to know that I had originally downloaded the DigiDB dedupe product for evaluation - but could never get the trial to work properly, nor could I get anyone at the company to address my tech support issues. I didn't buy, as I couldn't figure out if the product would work for my needs. I turned to your product, which was easy to download, install and use. Thank you.”
Danielle Doctorow wrote: “Your Duplicate Finder & Deleter product worked great. We were able to edit a huge mailing list, save postage, and printing costs for a fundraiser, not to mention avoiding irritating current and potential funders! I think I mentioned when we spoke that I base my purchases on the support available, and I am delighted to have purchased your product.”
Dena Granderson wrote: “I just wanted to say our company purchased the duplicate finder product, and it works great with our circulation department. Add-Ins.com offers not only outstanding products but also outstanding customer service. This company continues to improve on the quality of their products, and they care about your satisfaction. I am grateful that this company exists, and it has made my life much easier at work, so I recommend this company to anyone that is in need of good service and products that will make your working experience easier and successful.”
John Worner wrote: “Really good job on the duplicate finder update for cells. It made it possible for me to complete some of my metrics in time for the VP of Eng to review before presenting his case to the Enginerring Committee. If word of mouth advertisement is of value, then you have my backing.”
Daniel D. wrote: “Your Duplicate Finder product worked great. We were able to edit a huge mailing list and save postage and printing costs for a fundraiser, not to mention avoiding irritating current and potential funders! I think I mentioned when we spoke that I base my purchases on the support available, and I am delighted to have purchased your product.”

Customers who viewed the Duplicate Finder & Deleter also viewed