This add-on enables users to search and manage duplicated information in Excel spreadsheets. The software features tools for scanning rows or columns, searching a particular table or cell range, and comparing values or formulas.
One of the key functions of Remove Duplicates from Excel is the ability to search across columns and rows. You can easily find duplicated cells in rows or columns with the appropriate search mode, which you can access by pressing the corresponding button on the Microsoft Excel toolbar.
In addition to searching across columns and rows, Remove Duplicates from Excel also allows you to search across the entire table or a specified range of cells. You can start the program for searching the duplicated cells across the entire table or specify a range of cells before launching the program.
For more advanced users, there is an advanced mode that allows you to specify the columns or rows to be searched through for duplicates. By default, search is carried out across all rows and columns.
Another great feature of Remove Duplicates from Excel is the ability to choose a type of comparison. You can compare cells by values or by a formula, which will help you find the cells which contain identical values as a result of calculations.
Finally, once you've found the duplicated cells, Remove Duplicates from Excel offers different operations that you can perform. You can clear the contents, change formatting, remove a row or column with a shift of the table, or hide a row or column from the current view.
Overall, Remove Duplicates from Excel is a fantastic software that can save you time and effort when dealing with duplicated data. Its user-friendly interface and powerful search capabilities make it a must-have for anyone working with Microsoft Excel tables.
Version 1.1.6: Support for Microsoft Office 2016 and Windows 10 has been added.