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
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.
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.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With