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 …
In this guide, I’m going to show you how to apply an IF function in Excel 2016. Note that similar principles apply to previous versions of Excel. In general, IF functions allow you to perform logical tests in Excel. So what type of logical tests are we going to see in this guide? We’ll review the …
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’ll review few examples to illustrate how to apply the following Excel string functions: Excel String Functions Used Description of Operation LEFT Retrieve …
Excel String Functions: LEFT, RIGHT, MID, LEN and FIND Read More »
In this quick guide, I’ll show you the steps to repeat specific rows on every page when printing in Excel. The Example Let’s say that you have a list of 60 employees in Excel. This list contains the following column names: Employee First Name Employee Last Name Your goal is to print those two column …
Repeat Specific Rows on Every Printed Page in Excel Read More »
VLOOKUP is a powerful function in Excel. In this tutorial, I’ll show you how to use VLOOKUP in Excel 2016. Specifically, I’ll review an example with the steps needed to apply a VLOOKUP. But before we begin, let’s first review the elements of the VLOOKUP function. Elements of the VLOOKUP in Excel 2016 The VLOOKUP …
How to use VLOOKUP in Excel 2016 (example included) Read More »
Need to create a column chart in Excel? In this post, I’m going to show you the steps needed in order to create a column chart in Excel 2016. Excel 2016 offers additional features that you can use in order to create a fancy column chart. To explore those features, we will review a simple …
Need to create a drop-down list in Excel? If so, in this post I’ll show you the steps to create a drop-down list in Excel 2016. The example To start, let’s review an example where you have 5 simple tasks that you want to track: (1) Place a purchase order to buy a computer (2) Pay …
In this short guide, I’ll show you how to apply Conditional Formatting in Excel. The Example Let’s suppose that you have the following 5 by 5 matrix, which contains the grades of 25 students: 60 65 85 75 90 45 80 35 80 65 90 25 65 20 70 85 95 60 40 60 70 30 …
There are different arithmetic functions that you can execute in Excel. In this short guide, I’ll show you how to add, subtract, divide and multiply in Excel. Before we start, let’s look at the symbols that represent the basic arithmetic functions in Excel: The ‘+’ symbol is used to add/sum values The ‘-‘ symbol is used to …
How to Add, Subtract, Divide and Multiply in Excel Read More »
In this short tutorial, I’ll review 3 ways to obtain the Max value in Excel using the: MAX formula AutoSum Insert Function The Example For simplicity, let’s pick the following set of numbers: 22, 55, 38, 79, 63 The goal is to find the maximum value in Excel using each of the 3 methods above. …