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 …

Excel String Functions: LEFT, RIGHT, MID, LEN and FIND

Need to retrieve specific characters from a string in Excel? If so, in this guide, I’ll show you how to use the Excel string functions to obtain your desired characters within a string. Specifically, I will use examples to illustrate how to apply the following Excel string functions: Excel String Functions Used Description of Operation LEFT Retrieve …