Menu
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
449
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.
51
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
