Find the Duplicate entries in the list using Countif formula

To find out the duplicate entries in a list, we can use the COUNTIF formula. The COUNTIF function counts the number of cells in a range which meets the given criteria. With the help of COUNTIF function we can find out how many times a given entry is appearing in the list.

Syntax for COUNTIF Function:

=COUNTIF(range, criteria)

We will take a example of list of 20 names, in which we have to find out how many times a particular name is repeated. 

Following COUNTIF Formula will find how many times a particular name is repeated in the list.  Use the $ sign to fix the rage to the list.

Following is the result of the formula which shows 2 in front of duplicate entries. The duplicate entry name Adalberto and Marshall can be identified using COUNIF function

One Comment

Add a Comment

Your email address will not be published. Required fields are marked *