Google Sheets: Conditional Formatting to Find Duplicates (in one column)
Have you ever manually scanned through data looking for duplicates? You can sort the data alphabetically to help, but that still relies on your eye to pick up duplicates. However, you can use conditional formatting and a custom formula to highlight any duplicates in a column, making them easy to spot.
Formula: =countif($D:$D, D1) greater than 1
the formula counts all instances and marks whenever there are 2 or more of any value
Make a copy of the demo sheet and follow along: https://doittraining.page.link/democo...
Slides: https://doittraining.page.link/condit...
Watch video Google Sheets: Conditional Formatting to Find Duplicates (in one column) online, duration hours minute second in high quality that is uploaded to the channel DoIT Training at Stony Brook University 07 December 2017. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 9,317 times and liked it 38 visitors.
