Friday, 27 July 2012

How to find Duplicates in a Particular Column or in a List of Data using Count IF Function

Excel CountIF Function to find Duplicates in Particular Column has a List of Data
We can find the duplicates in particular column using CountIF and IF functions combination.
Syntax:
=COUNTIF (Array, Value)
Here:
Array refers to the range of data where you want to find duplicates
Value refers to the value for which you test uniqueness.
Example:
Suppose Column A has a list  of data , in that if you want find the duplicates ,you have to write a formula in Column B as shown below.

=IF(COUNTIF($A$2:A2,A2)>1,"Duplicate","Unique")

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts