Microsoft Excel Addons

We also have Free training videos on this site ( visit the Home page or the Training Page)

Microsoft Excel Addons for Duplicate Management

A wide range of Microsoft Excel Addons are available from Audit Excel. One of the useful Microsoft Excel Addons worth a mention is the duplicate location and removal tool.

Duplicate locater and remover

As one of the best Microsoft Excel Addons, the handy tool can handle up to a million rows and is thus suitable for large spreadsheets and workbooks. It allows for the easy location of duplicates including:

• Rows
• Cells
• Typo mistakes
• Spelling mistakes
• Records.

Three main tools are available to handle the above functions effectively:

• Duplication remover
• Duplication manager
• Blurry duplication locator.

Duplication remover

The tool allows for the selection of duplicates and colour coding or deleting them. You will also be able to compare the lists with different columns. It is possible to locate duplicates in the same range or in two different lists. Once located the duplicates can either be deleted or copied to another worksheet.

Duplication manager

The tool is useful for locating and deleting duplicate rows and cells from tables and lists. The tool can be used for duplicates in the same range and different lists. It is used for the removal of absolute duplicates. You will be able to create lists of unique data or specify that only unique data should be displayed. The creation of a summary report is part of the tool’s functionality. Up to three levels of colour coding is possible.

Blurry duplication locator

Locates and allows for editing of blurry duplications, misspellings, and typos. It also allows for the location of duplicate records and entries. The tool is useful for duplicates which differ in one to six symbols and can thus find those hidden duplicates easily.

View our products and download pages for more useful Microsoft Excel Addons which form part of the Spreadsheet Professional package.