How To Compare Two Sheets For Duplicates in Google Sheets

Last Updated on November 1, 2023 by Jake Sheridan

In this tutorial, you will learn how to compare two sheets for duplicates in Google Sheets

How To Compare Two Sheets For Duplicates in Google Sheets

When working with data in Google Sheets, you may find yourself with two sheets that contain similar data. For example, you may have a sheet of data from last year, and a sheet of data from this year. You want to find out which values are duplicates between the two sheets.

One way to do this is to use the COUNTIF function. This function allows you to count the number of cells in the first sheet that match a particular value in the second sheet.

In this guide, we will show you how to use the COUNTIF function to compare two sheets for duplicates in Google Sheets.

How to Find Duplicates Between Two Sheets in Google Sheets

Here’s how to find duplicates between two sheets in Google Sheets.

Step 1

Select an empty cell where you can place unique values from the first sheet.

Step 2

We’ll use the UNIQUE function to return the list of unique transactions from the first spreadsheet.

Step 3

Use the UNIQUE function again to return the unique transactions of the second sheet to compare.

Step 4

We’ll use the COUNTIF function to count how many times each transaction appears in the other sheet. This will allow us to find duplicates between each sheet.

Use the Fill Handle tool to ensure that each value is checked for duplicates.

Step 5

We’ll add the same formula for the second list of transactions.

Summary

This guide should be everything you need to compare two sheets for duplicates in Google Sheets.

You may make a copy of this example spreadsheet to test it out on your own.