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.
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.
Highlight the columns or rows that you want to locate duplicates in.
Right click on the area highlighted and click on “Conditional Formatting”.
In the dropdown under “Format cells if…” choose “Custom formula is”.
Paste this formula into the box: =COUNTIF($A$2:G,Indirect(Address(Row(),Column(),)))>1
Click green “Done” button.
Visual Guide to Finding Duplicates in Two Columns in Google Sheets
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).