Latest Blog Posts - Page 523 of 587

How to Use a Dynamic VLOOKUP in Excel – 3 Methods

Aug 11, 2024

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 Use a Dynamic VLOOKUP in Excel – 3 Methods

How to Add Sequence Number by Group in Excel (2 Ways)

Jul 3, 2024

Method 1 - Using COUNTIF Function to Insert Sequence Number by Group Steps: Go to Cell C5. Enter the COUNTIF function. Select the range ...

How to Add Sequence Number by Group in Excel (2 Ways)

How to Insert Excel Sheet Name from Cell Value (3 Easy Ways)

Jul 3, 2024

Method 1 - Combining MID, CELL, and FIND Functions to Insert the Sheet Name into Cell Value Consider the following dataset. We want to insert the ...

How to Insert Excel Sheet Name from Cell Value (3 Easy Ways)

How to Delete Multiple Rows with VBA in Excel (4 Ways)

Nov 11, 2025

In this article, I’ll show you how you can delete multiple rows in Excel with VBA. The article will combine deleting multiple rows of a selected ...

How to Delete Multiple Rows with VBA in Excel (4 Ways)

How to Find a Case Sensitive Match in Excel (7 Methods)

Jul 13, 2024

Dataset Overview We have the following sample dataset which we are going to use to demonstrate the 7 methods. The dataset contains columns for ID ...

How to Find a Case Sensitive Match in Excel (7 Methods)

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

May 28, 2024

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 Count Blank Cells with Condition in Excel: 4 Easy Methods

How to Use COUNTIFS Function with Multiple Criteria in Excel?

Aug 2, 2024

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

How to Use COUNTIFS Function with Multiple Criteria in Excel?

How to Delete Row If Cell Contains Value Using Macro in Excel (2 Examples)

Jul 6, 2024

In this article, we will use a VBA macro to delete cells that contain either a string or numbers, as in the following gif. The VBA syntax ...

How to Delete Row If Cell Contains Value Using Macro in Excel (2 Examples)

How to Count If Cell Contains Number in Excel: 5 Smart Ways

Apr 16, 2024

To determine if a cell contains a number, we can use the COUNT, COUNTIF, SUBTOTAL, COUNTIFS, SUBTOTAL, and ISNUMBER functions. Consider the following ...

How to Count If Cell Contains Number in Excel: 5 Smart Ways

How to Count Months in Excel (5 Easy Ways)

Jul 6, 2024

We used the functions COUNTIF and MONTH to count the month between dates, and here's the overview. How to Count Months in Excel: 5 Easy ...

How to Count Months in Excel (5 Easy Ways)

How to Count Filled Cells in Excel (5 Quick Ways)

Jun 13, 2024

Method 1 - Using the COUNTA Function to Count Filled Cells in Excel We'll use a sample dataset of sales in different states. Some cells are empty. ...

How to Count Filled Cells in Excel (5 Quick Ways)

Example of Mixed Cell Reference in Excel (3 Ideal Types)

Nov 11, 2025

Any Excel worksheet is made of numerous cells. These cells are referenced based on their row or column position for calculation. There are 3 types of ...

Example of Mixed Cell Reference in Excel (3 Ideal Types)

How to Name a Range in Excel (5 Easy Tricks)

Nov 11, 2025

In Microsoft Excel, there are several methods to name a range and make it also dynamic simultaneously. The named ranges are easy to prepare. They are ...

How to Name a Range in Excel (5 Easy Tricks)

How to Check If Multiple Cells Are Equal in Excel (4 Methods)

Apr 23, 2024

We’ll input a group of words in some random cells in different columns and check if they are equal or not. Overview In the following image, ...

How to Check If Multiple Cells Are Equal in Excel (4 Methods)

How to Delete Row If Cell Is Blank in Excel?

Jul 29, 2024

We have some rows with blank cells, and we'll delete entire rows that have blanks. Method 1 - Using the Go To Special Command Select ...