How to Count Duplicates in Excel

In this tutorial, you will learn how to filter a column by multiple values in Excel.

The COUNTIF formula in Excel can be used to count duplicates.

Once you are ready, we can start by using real-life scenarios to help you understand how to count duplicates in Excel.

Anatomy of COUNTIF Function

COUNTIF(range, criteria)

COUNTIF function is used to determine how many cells satisfy a requirement

Count Duplicates in Excel

Before we begin we will need a group of data to be used to filter a column by multiple values in Excel.

Step 1

First, you need to have a clean and tidy group of data to work with.

Step 2

In this example, we want to know how many times is ‘Red’ and ‘Yellow’ duplicated. We will insert the following formula =COUNTIF($A$2:$A$8,C2).

Step 3

Once we are done, you will be able to count the duplicates of ‘Red’ and ‘Yellow’.