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 without registration, duration hours minute second in high quality. This video was added by user DoIT Training at Stony Brook University 07 December 2017, don't forget to share it with your friends and acquaintances, it has been viewed on our site 9,317 once and liked it 38 people.