Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

highlight duplicate Value in Open Office org Calc

I am using OPEN OFFICE ORG CALC.

I can't use MSOFFICE

How can i highlight Duplicate value in a Column ?

I am in real need. Did my part of homework LINK 1, Link 2

like image 449
Prahalad Gaggar Avatar asked Jun 15 '13 13:06

Prahalad Gaggar


People also ask

How do I highlight duplicates in Openoffice Calc?

Use the $ signs to Fix the search range. The next step could be to us this in a conditional format formula. Maybe not as nice (and smooth) as in Excel, but it highlights, duplicates. Put the formula in e.g. Cell A1 , then use the format paintbrush to copy the format down.


Video Answer


1 Answers

One simple way is to use countif. See image. Use the $ signs to Fix the search range. The next step could be to us this in a conditional format formula.

enter image description here

enter image description here

Maybe not as nice (and smooth) as in Excel, but it highlights, duplicates. Put the formula in e.g. Cell A1, then use the format paintbrush to copy the format down.

like image 51
Robert Ilbrink Avatar answered Nov 12 '22 05:11

Robert Ilbrink