How Do I Find Duplicates in Two Columns in Google Sheets?

Updated: 7 days ago

When it comes to analyzing data on Google Sheets, sometimes is important to see where there are duplicates in two columns.


This is especially helpful if you've synced two Google Sheets into one master sheet or perhaps you have set up colored dropdown lists in your sheet and want to see duplicates.





Another great use for finding duplicates in two columns is if you are using Google Sheets to pull in historical stock data. You can easily analyze the data using this method.


So how do I find duplicates in two columns in Google Sheets? Thankfully Google has made it very simple with conditional formatting.

  1. Highlight the columns or rows that you want to locate duplicates in.

  2. Right click on the area highlighted and click on “Conditional Formatting”.

  3. In the dropdown under “Format cells if…” choose “Custom formula is”.

  4. Paste this formula into the box: =COUNTIF($A$2:G,Indirect(Address(Row(),Column(),)))>1

  5. Click green “Done” button.



Visual Guide to Finding Duplicates in Two Columns in Google Sheets



Step 1:


Highlight the columns or rows that you want to find duplicates in. You do this by clicking and dragging over the column letters or row numbers (i.e. I highlighted columns A and B).