Mark unique values

Range > Mark unique values

This utility marks cells with unique (non-repeating) values in yellow in the selected range.

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

Designating unique values is the reverse process to marking duplicates .

Screenshot

Running this tool

Click YLC Utilities > Range > Mark unique values :

Excel:

LibreOffice Calc:

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 (Calc) , the amount of data you work with, and how often you use this tool.

Download extension

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

After that, this function will be available in all files that are opened in Excel (LibreOffice Calc) .