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
Comments
Post a Comment