In this How to Google video we show you how to check for duplicates in google sheets. This is not the only way how to check for duplicates in google sheets but this is a pretty easy way to do it.
How to Check for Duplicates in Google Sheets is relatively simple. Here is how you do it.
First. Select the data you want to check
Then go to Format,
Then Custom Format
Then Enter the Countif Formula as the criteria. See video for details.
Now you know How to Check for Duplicates in Google Sheets and can clean up your google sheet duplicate data like a pro!
Let me know if this helped you find How to Check for Duplicates in Google Sheets or not. If you need more help you can always click on the help tab and search there
If you liked this quick How to Google video on "how to check for duplicates in google sheets", please Like and Subscribe for more videos.
As always please if you have questions, comments, suggestions, or an idea you would like to see please comment below or contact us
Intro Video Credit to Google.com - Doodle published 09/01/15