Learn Two Methods to Identify Duplicates in Google Sheets

This post is written to accompany the YouTube video showing how to identify duplicates in your Google Sheet.

Conditional Formatting Function – For starting in cell A2

=COUNTIFS($A2:$A,$A2,$B2:$B,$B2,$C2:$C,$C2)>1

IF statement – Written as if it started in row 2 and looks at three columns

=IF(COUNTIFS(A$2:A2,A2,B$2:B2,B2,C$2:C2,C2)>1, "Duplicate", "")

 Live examples in Sheets

Go to this spreadsheet for examples of identifying duplicates that you can study and use anywhere you would like.

Using a plugin

As an alternative to the options above, you may want a plugin to do the heavy lifting for you. I like to use a plugin called Power Tools. This will give you a menu option with, among other things, several options to deal with duplicates. You can use the plugin to combine or remove duplicated rows.

Dedupe and Compare Menu
Dedupe and Compare Menu

Disclosure: This is an independently owned website that sometimes receives compensation from the company's mentioned products. Prolific Oaktree tests each product, and any opinions expressed here are our own.

One thought on “Learn Two Methods to Identify Duplicates in Google Sheets

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>