COUNTIF to identify duplicate data

Excel provides a easy way to eliminate duplicate data. But what if you want to know what data is duplicated.

Well the solution is the function COUNTIF

The COUNTIF function is used to count up the number of cells in a selected range that meet certain criteria.

The syntax for the COUNTIF function is:
=COUNTIF ( Range, Criteria)

Range - the group of cells the function is to search. 

Criteria - determines whether the cell is to be counted or not. This can be a number, expression, cell reference, or text string. 


In this example I have the formula in Column B. I show the formula entered in Column B in Column C.


















Using COUNTIF in this manor allows you to identify how many instances of each value in the range of data in Column A. Anything greater then 1 is at least duplicated. In this example there are some triplicate results (indicated by the #3).


How do you identify duplicate data?

No comments:

Post a Comment