## 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…