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  a 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")

Thanks, TAMATAM

No comments:

Post a Comment

Hi User, Thank You for Visiting My Blog. Please Post Your Feedback/Comments/Query.

Subscribe to Blog Posts by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts