How to Highlight Duplicates in Google Sheets
When you have data in a column in Google Sheets that contain duplicate values, you may want to highlight them for further analysis or deletion. A quick way to do that is by using Conditional Formatting. Go to Format -- Conditional Formating -- Use Custom Formula.
The formula is =countif(range,first cell) more than 1
The range has to have $ signs.
=COUNTIF($A$2:$A$10,A2)morethansymbol1)
*YouTube doesn't allow the more than symbol so you have to put that for the "morethansymbol" words
Shorts version: • Highlight Duplicates in Google Sheets...
#akaakidesign #akistepinska
