Mark duplicate values

Range > Mark duplicate values

This utility colors the repeated values in your selection.

Each set of duplicate values is given its own unique color. This helps you quickly find repeated values by having a set of colors that are each easily distinguishable from one another.

For example, if your selected range contains 5 cells with the value "Montreal", then those 5 cells will have the same color, such as yellow. And if the value "New York" exists in 2 cells, then those 2 cells will also have the same but different color, such as green.

This utility is case-sensitive, which means, for example, that "Calc" and "CALC" are not the same If your selection contains formulas, this utility compares the calculated values. This means that this utility considers the cell with the value 12 and the cell with the formula =3*4 as duplicates.

Marking duplicates is the reverse process of marking cells with unique values .

Screenshot

Launch this tool

Click YLC Utilities > Range > Mark duplicate values :

This utility uses 16 different colors to indicate each set (groups) of duplicates. If the number of groups exceeds this number, this tool will reuse the set of colors.

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" .