Mark outliers

Range > Mark odd values

This utility marks cells with excess values in yellow in the selected range.

You can, for example, use it to highlight redundant values in a selected set of cells and then quickly filter them out using standard tools.

The designation of redundant values is similar to the utility marking duplicates , but does not paint over the first occurrence of a duplicate value.

Screenshot

Running this tool

Click YLC Utilities > Range > Mark odd values :

How much time will this save?

Using this tool will definitely save you time and effort. However, the actual time savings will depend on how often you use it. Excel , the amount of data you work with, and how often you use this tool.

Download extension

You can use the utility Mark odd values by installing the extension YLC Utilities .

After that, this function will be available in all files that are opened in Excel .