TOP

Mark different values

Range > Mark distinct values

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

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

You can also use this utility to quickly create a dropdown list , which requires a list of unique values.


Screenshot

Range > Mark distinct values

Launch this tool

Click YLC Utilities > Range > Mark distinct values :

Range › Mark different values

How much time will it save?

Using this tool, you are guaranteed to save time and effort. However, the actual time savings depends on how often you use LibreOffice Calc, the amount of data you work with, and how often you use the tool.

Download

If you don't already have YLC Utilities, you can download the free version "YouLibreCalc.oxt" or the full-featured version "YLC_Utilities.oxt" .


Additional keywords for this tool:
different values, records, strings, count different values, how to find the same values, formula to get unique values, create a list