highlight duplicate Value in Open Office org Calc

duplicates openoffice.org openoffice-calc
Prahalad Gaggar picture Prahalad Gaggar · Jun 15, 2013 · Viewed 29k times · Source

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

Answer

Robert Ilbrink picture Robert Ilbrink · Jun 16, 2013

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.

Related questions

Finding duplicate values in a SQL table

It's easy to find duplicates with one field: SELECT name, COUNT(email) FROM users GROUP BY email HAVING COUNT(email) > 1 So if we have a table ID NAME EMAIL 1 John [email protected] 2 Sam [email protected] 3 Tom asd@…

Read More
Remove duplicate values from JS array

I have a very simple JavaScript array that may or may not contain duplicates. var names = ["Mike","Matt","Nancy","Adam","Jenny","Nancy","Carl"]; I need to remove the duplicates and put the unique values in a new array. I could …

Read More
Removing duplicates in the lists

Pretty much I need to write a program that checks if a list has any duplicates and if it does it removes them and returns a new list with the items that weren't duplicated/removed. This is what I have …

Read More