Excel Functions

Excel SUMIF with Partial Match (3 Easy Ways)

In this tutorial, we will describe how to use the SUMIF function based on a partial match in three different scenarios: at the beginning of a value, ...

How to Vlookup Multiple Values in Excel

Method 1 - Using COUNTIF and VLOOKUP Functions to Vlookup Multiple Values Select cell C5 to add the salesperson's number. ...

How to Lookup Across Multiple Sheets in Excel (3 Easy Methods)

Suppose a bookshop sells books both online and in stores. However, they have two booklists, one featuring books available for online sale and the ...

How to VLOOKUP Multiple Values in One Cell in Excel (2 Easy Methods)

We have a dataset with salesperson Names and their selling Products. Our goal is to find the selling products of each salesperson. Method 1 - ...

How to VLOOKUP and SUM Across Multiple Sheets in Excel

  The sample sheets are for 3 consecutive months: January, February, and March, containing the Product Name, Product ID, and Sales for each ...

How to Use COUNTIF for Cells Not Equal to Text or Blank in Excel – 5 Examples

This is a sample dataset of the electricity bill of a Store in the 1st 6 six months of 2021. The column Result was added to the dataset. ...

How to Remove the Last 3 Characters in Excel (4 Easy Ways)

We will show you four distinct formulas to remove the last 3 characters in Excel with ease. We'll use a simple dataset that contains employee ...

How to Sum If Cell Contains a Text in Excel (6 Suitable Examples)

We will be using a sample product price list as a dataset to demonstrate all the methods throughout the article. Let’s have a sneak peek of it: ...

How to Make VLOOKUP Case Sensitive in Excel?

Consider the following dataset of students. In that dataset, there are two students who have the same first names but different surnames and obtained ...

How to Compare 4 Columns in Excel VLOOKUP (7 Methods)

Dataset Overview In this scenario, we have data from two companies, and we want to compare whether their product names and item colors match. We ...

How to Use a Dynamic VLOOKUP in Excel – 3 Methods

Method 1 - Using a Dynamic VLOOKUP with the MATCH Function This is the sample dataset. To find an employee’s information according to the ID and ...

How to Count Blank Cells with Condition in Excel: 4 Easy Methods

Method 1 - Using IFS and COUNTIF Functions to Count Blank Cells with Condition in Excel Steps: ❶ Select cell G5 ▶ enter the formula below. ...

How to Use COUNTIFS Function with Multiple Criteria in Excel?

The sample dataset has the Order Date, Category, Product, Quantity, and Unit Price columns. We'll use COUNTIFS with criteria in it. ...

Excel VLOOKUP to Find Last Value in Column (with Alternatives)

Finding a value in a column - a vertical lookup - is a common task when working in Excel. Excel provides a built-in VLOOKUP function for this ...

How to Use Excel VLOOKUP to Find the Closest Match

In this article, we will demonstrate five examples of how to efficiently implement Excel VLOOKUP to find the closest match in Excel. As an example ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo