Latest Blog Posts - Page 440 of 589

How to use Excel VBA with an Advanced Filter – 6 Examples

Aug 15, 2024

This is the sample dataset. Example 1 - Use Excel VBA to Filter Data in the Current Location Set the criteria in B16:E17. Step 1: ...

How to use Excel VBA with an Advanced Filter – 6 Examples

How to Count Unique Values Based on Criteria in Another Column in Excel (4 Methods)

Jul 29, 2024

Dataset Overview Imagine we have an Excel file containing data about various fruits exported by a businessman to different European countries. The ...

How to Count Unique Values Based on Criteria in Another Column in Excel (4 Methods)

How to Use IF Statement in Data Validation Formula in Excel (6 Ways)

Apr 16, 2024

Here, we have some records of some of the products and their corresponding salesperson’s names of a company. By using this dataset, we will ...

How to Use IF Statement in Data Validation Formula in Excel (6 Ways)

Apply Custom Data Validation for Multiple Criteria in Excel (4 Examples)

May 25, 2024

In this article we'll discuss how to use Custom Data Validation with multiple criteria to prevent incorrect or out-of-range data being entered into a ...

Apply Custom Data Validation for Multiple Criteria in Excel (4 Examples)

How to Deal with Blank Cells That Are Not Really Blank in Excel (4 Ways)

Jun 18, 2024

Sometimes you may think a cell is blank because there’s nothing visible in it. But it may not actually be blank. There might be a formula that ...

How to Deal with Blank Cells That Are Not Really Blank in Excel (4 Ways)

VBA Conditional Formatting Based on Another Cell Value in Excel

Nov 11, 2025

When we are dealing with a large amount of data in Excel, sometimes we want to format the dataset in certain conditions for better readability. ...

VBA Conditional Formatting Based on Another Cell Value in Excel

Fix Circular Reference That Cannot be Listed in Excel (4 Easy Ways)

Nov 11, 2025

In this article, we will demonstrate how to fix the Excel circular reference that cannot be listed in Excel. It’s very intimidating if you get ...

Fix Circular Reference That Cannot be Listed in Excel (4 Easy Ways)

How to Find Last Business Day of Month in Excel (9 Handy Ways)

Nov 11, 2025

This article illustrates how to find the last business day of a month in Excel. It also shows how to find the last business day/workday in any year. ...

How to Find Last Business Day of Month in Excel (9 Handy Ways)

Excel VBA: Count Characters in Cell: 5 Methods

Jun 6, 2024

Method 1 - Use of VBA Len Function to Count Characters in a Cell in Excel The LEN function in VBA Excel returns the number of characters in a text ...

Excel VBA: Count Characters in Cell: 5 Methods

How to Move a Group of Cells in Excel (4 Easy Ways)

Jul 29, 2024

In this article, we will demonstrate how to use multiple Excel features and keyboard shortcuts to move a group of cells in Excel, be they in rows, ...

How to Move a Group of Cells in Excel (4 Easy Ways)

How to Select Cells with Certain Value in Excel (5 Methods)

Jul 29, 2024

Dataset Overview Occasionally, we need to locate and highlight cells with specific values in an Excel spreadsheet. Since Excel typically contains a ...

How to Select Cells with Certain Value in Excel (5 Methods)

How to Create a Dynamic Drop Down List Using the Excel OFFSET Function – 3 Methods

Aug 9, 2024

The dataset showcases sports Event(s) and the List of Winners. Method 1 - Create a Dynamic Drop Down List with the OFFSET and the COUNTA ...

How to Create a Dynamic Drop Down List Using the Excel OFFSET Function – 3 Methods

How to Count Filtered Rows in Excel with VBA (Step-by-Step Guide)

May 18, 2024

Suppose you have the following dataset. Step 1 - Apply a Filter to the Dataset Select any cell of your dataset. Go to the Data ...

How to Count Filtered Rows in Excel with VBA (Step-by-Step Guide)

How to Convert Number to Text without Scientific Notation in Excel

Jul 29, 2024

In Excel, if you input a number with 15 or more digits, although the number is stored in number format as usual, it is displayed by default in ...

How to Convert Number to Text without Scientific Notation in Excel

Ways to Count Characters in Cell Without Spaces in Excel: 2 Methods

Jun 28, 2024

Combining LEN and SUBSTITUTE Functions You can use a formula combining LEN and SUBSTITUTE functions to count the number of characters within a cell. ...