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 using COUNTIFS – For starting in cell A2


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.

0 thoughts on “Learn Two Methods to Identify Duplicates in Google Sheets

  • Teddy Mondres says:

    Hello there! I appreciate your videos, they’re very informative!
    Right now I’m looking for a formula to be used in conditional formatting, such that cells in a column will be highlighted if their addresses, such as $A$1, are entered/matched in another column. I’m thinking a combination of the formulas MATCH and ADDRESS, but can’t quite figure it out. And there may not have been help on this online. Thanks for your help!

  • I am trying to set up the duplicate finder for rows d & e and they are not single words like shown as in your video. My rows have full sentences. How can I make the duplicate word finder work for my specific situation?

Leave a Reply