Hello Friends, in this article, I will answer the question How To Check Duplicates In Excel? in three different ways, which will be very useful for you I will show you my real data There are some duplicate records here.
Now how to deal with duplicate records, see all these six examples, you will understand them well and you will get to learn some new ways about how to find duplicate values in Excel.
Also Read: Social Security Breach: Has Every American’s Privacy Been Hacked?
How To Check Duplicates In Excel Method 1
The first and most common method is to use the remove duplicate feature which is inbuilt in Excel.
- So what you will do is click anywhere in the data.
- Go to the data tab.
- Here you will find the option to remove duplicates.
- Click on it and a small window will appear in front of you.
- Tick your table headers and delete all the duplicate rows
- This is the most common way to delete the duplicate in Excel
How To Find Duplicate Values In Excel Method 2
The second method to check duplicates in Excel is. I have taken only the data of email IDs for a brief understanding so that you can understand it.
- Select this column here, go to condition format,
- Go to highlights and click on the duplicate value.
- Now what will happen is that the duplicate values will appear in front of you in color but will not be removed.
- Right now I am only showing you to identify them at a time. Now you can give custom color to it by going to custom format.
- So we will know that this entry is a duplicate.
Now what do we do here, we have found, and here I will teach you how to remove it, so to remove it
you have to select the column or the data and after that, you go to remove duplicates in the data, there will be a simple option, whatever duplicate data of yours is, tick it if it is not ticked in your Excel.
Now press OK, now you will find that whatever duplicate is there in your data will start appearing on your Excel sheet, whatever duplicate value is found, then as soon as you press OK, all the values will become unique.
How To Find Duplicate Values In Excel Method 3
We want to determine which duplicates are thereby applying a formula in our data. So let’s do it now. I will apply the (=COUNTIF(A2:A16, “Monitor”) formula here.
- Now you have to give the range here. After selecting your column, you have to apply the dollar here.
- Now you have to give the criteria here. In the requirements, you must give the data you want to find. And close the bracket.
- Now if this value is found and there is more than one value, only then it will be considered a duplicate.
