How to identify duplicate values in Google Sheets 👀 || Google Sheets || countif() function

No matter how careful you are entering and collating the data, duplicates can happen.

While Microsoft Excel offers an easy way to find duplicates, Google Sheets doesn’t provide convenient options.

But with the help of conditional formatting and custom formula, we quickly identify duplicates in a few clicks.

There are two ways to do it, and I will show you how. 👇

👉Using conditional formatting option
1. Select the range where you want to find the duplicates.
2. Go to Format and click on Conditional Formating.
3. Choose ‘Custom Formula is’ from the Format rules dropdown.
4. Write the custom formula =countif()[watch the video for custom formula] in the value or formula text box.
5. Choose the color, format of the duplicate values, or cells having duplicate values from the Formatting style.
6. Click on Done.
7. All the duplicate values are highlighted in formatting style.

👉Using the COUNTIF() formula
1. Write the custom formula =countif()[watch the video for custom formula] in a column and hit the enter button.
2. It will give you results in True and False. True means the value is duplicate, and False means it is not duplicate.
3. Copy and paste the formula till the end of the data.
4. All the duplicate values have True.

Let’s try it practically in Google Sheet