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.
=COUNTIF (Array, Value)
Array refers to the range of data where you want to find duplicates
Value refers to the value for which you test uniqueness.
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.



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