Duplicate Remover for Microsoft Excel

Duplicate Remover for Microsoft Excel 2.6

An add-in designed to find duplicated data in Excel worksheets
5.0  (1 vote)
2.6.4 (See all)

Duplicate Remover is an add-in application that runs directly in practically any version of Microsoft Excel; once the user installs it on his/her computer, a new tool is added to the toolbar, with two simple buttons responsible for the whole process.

When you're working with long worksheets with large amount of data in them, it's difficult to keep them clean of duplicates either introduced as a human error or because of the kind of the managed information. Excel does provide a native search engine, but the user has to provide some specific data to search for. This makes searching for duplicate entries a very complicated task that consumes a lot of time. With this tool, you will save time and avoid headaches, because it finds duplicated data easily; and you can specify a range of cells in a specific table, or choose to compare data stored in two different tables, or even find unique entries in different tables. Once you find the data you were searching for, you can choose to delete duplicates, highlight their cells, copy them into another workbook, or just select them (to analyze them carefully afterwards).

The program is designed to be an assistant in the process, so its wizard interface is very intuitive; it guides the user step by step. The developer says that the program is capable of analyzing up to one million rows of data in one or two Excel lists. Another advantage that this tool presents is that it is not programmed as a macro (which can embed viruses or malicious codes), so it is pretty safe to use.

The bad news is that once you delete or change the duplicated data, it is impossible to recover them: there is no function or command to undo the last step, so it would be a good idea to back up the file before using this tool or deleting the cells. It would be even better to use the option to color the cell to decide if they contain useless information.

Eduardo Trejo
Editor rating:

Review summary

Pros

  • Great for huge amounts of data contained in a single worksheet
  • Great for comparing data contained in two different tables or worksheets

Cons

  • There is no function or command to undo the last step
Info updated on: