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.
Table of Contents
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’.
