Ablebits Ultimate Suite For Excel 2021 Business... — Limited Time

Advanced tools to find and remove duplicates across one or two tables, highlight unique values, trim extra spaces, and fix "fuzzy" typos or near-matches.

A built-in Formula Editor for managing long formulas in a tree view and utilities to sum or count cells based on their background or font color. Business vs. Personal Edition AbleBits Ultimate Suite for Excel 2021 Business...

The suite adds specialized tabs to your Excel ribbon, organized into functional groups: Advanced tools to find and remove duplicates across

Easily transpose ranges, unpivot cross-tab tables into flat lists, and swap cells, rows, or columns. highlight unique values

Quickly change text case, split names into separate columns (first, middle, last), extract substrings, and use Regex (regular expressions) for advanced searching.

It does not require administrative rights to install, as it installs to the user's AppData folder.