## How to Count Duplicates in Excel using COUNTIF

You can use the COUNTIF function to count duplicates in Excel: =COUNTIF(range, criteria) In this short post, I’ll review a simple example with the steps to count duplicates for a given dataset. Steps to Count Duplicates in Excel using COUNTIF Step 1: Prepare the data that contains the duplicates To start, let’s say that you have the following …