Excel : Select and Count Duplicate Values

This tutorial explains how to select and count duplicate values in Excel.

Sample Data
Sect Duplicate Values

Formula : See the Duplicate Values

Step I :
Paste =COUNTIF($B$3:$B$15,B3) in cell C3 and paste it down till cell C15
Step II :
 Apply filter on column C and uncheck 1. It filters duplicate values.
Count Duplicate Values
=SUMPRODUCT((1/COUNTIF(B3:B15,B3:B15)<1)*((1/COUNTIF(B3:B15,B3:B15))))
Related Articles
1. 3 Ways to extract unique values
2. Count Unique values in a column
3. Count Unique values in multiple columns

Excel Tutorials : 100 Excel Tutorials

About Author:

Deepanshu founded ListenData with a simple objective - Make analytics easy to understand and follow. He has over 7 years of experience in data science and predictive modeling. During his tenure, he has worked with global clients in various domains like banking, Telecom, HR and Health Insurance.

While I love having friends who agree, I only learn from those who don't.

Let's Get Connected: Email | LinkedIn

Get Free Email Updates :
*Please confirm your email address by clicking on the link sent to your Email*
Related Posts:
0 Response to "Excel : Select and Count Duplicate Values"

Post a Comment

Next → ← Prev