If you often work with extensive Microsoft Excel files, then you’ve certainly encountered duplicated items on the existing sheets. Duplicate Remover for Microsoft Excel is a small tool that can search for redundant information in a file.
The program has a simple interface that is quite easy to figure out, thanks to the intuitive layout.
As mentioned, the app searches for duplicates and lets you compare two lists with different numbers of columns for comparison. This can be done immediately after installing the program.
After loading the image, the program provides a complete list of the existing sheets and you must choose in which to have the program conduct the search.
Furthermore, you may also opt to locate duplicate values in the two tables or unique values. The program can ignore extra spaces in matching columns and cells.
Additionally, the utility lets you choose the key columns for the entire process. These can be selected manually or automatically detected by the program.
Once the app locates the desired values, it can perform several tasks. For instance, it can select them, change the color of the values, add a status column, copy or move to another location or delete them.
The process doesn’t take very long, but it depends on the size of the file. Varying on the action you chose the program prompts you before running it.
All in all, Duplicate Remover for Microsoft Excel is a nice tool that can come in handy quite often. Inexperienced individuals shouldn’t have any problems with working with it, thanks to the intuitive interface.
Limitations:
· 15 days trial
· Nag screen
What's New in This Release:
· ADDED: Warning that the Undo option is not available if the add-in transforms data, suggestion to create a backup copy of the sheet when possible.
· FIXED: 'Fill with color' option design.
· FIXED: There was not enough focus on action in the Dedupe table tool.
· FIXED: The message 'Select at least one column for comparison' in the Duplicate Remover tool.
· FIXED: Data outside of Excel table were included in the selected range.
· IMPROVED: Excel color palette is used for picking new background color for the found values.
· IMPROVED: Final step design.
· UPDATED: Ignore empty cells option is renamed to Skip empty cells.
· UPDATED: Select All and Unselect All buttons are replaced with a check box in the header.