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. LO Calc , 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 LibreOffice Calc .