Latest Blog Posts - Page 416 of 584

VBA to Loop through Rows of Table in Excel (11 Methods)

Apr 27, 2024

Consider the following dataset, which we'll use to showcase looping through rows in a table. Method 1 - Embed VBA to Loop ...

VBA to Loop through Rows of Table in Excel (11 Methods)

How to Find Lowest Value in an Excel Column (6 Ways)

May 14, 2024

To demonstrate all the methods, we'll use the same dataset below. It shows Bitcoin prices by months in dollars. We'll look for the lowest price on ...

How to Find Lowest Value in an Excel Column (6 Ways)

How to Add Dashes to SSN in Excel (6 Methods)

Jul 15, 2024

Microsoft Excel offers multiple ways to add dashes to social security numbers (SSNs), including using formulas or the Format Cells dialog box. In ...

How to Add Dashes to SSN in Excel (6 Methods)

How to Use VBA for Each Row in a Range in Excel

Jul 24, 2024

In this article, we will demonstrate how to use Excel VBA to iterate through each row in a range effectively, where the rows contain either single or ...

How to Use VBA for Each Row in a Range in Excel

How to Extract Text Between Two Commas in Excel: 4 Methods

May 25, 2024

Method 1 - SUBSTITUTE and MID Functions to Extract Text Between Two Commas Steps: Select cell C5 and write down the following formula for the ...

How to Extract Text Between Two Commas in Excel: 4 Methods

How to Extract Text after the Second Space in Excel – 6 Methods

Aug 7, 2024

The dataset contains information about Sales Amount and sellers' performance. To extract text from Column D: Method 1- Using the MID ...

How to Extract Text after the Second Space in Excel – 6 Methods

How to Extract Unique Items from a List in Excel – 10 Methods

Aug 3, 2024

Method 1 - Using the Excel Array Formula to Extract Unique Items from a List The following Product List contains ID No and Product Name. There is a ...

How to Extract Unique Items from a List in Excel – 10 Methods

How to Split Data into Multiple Columns in Excel (5 Methods)

Jul 28, 2024

Dataset Overview We'll use the following data set to split data into multiple columns using Excel functions. Method 1 - Using ...

How to Split Data into Multiple Columns in Excel (5 Methods)

Extract Data from One Sheet to Another Using VBA in Excel (3 Methods)

May 23, 2024

Watch Video – Extract Data from One Sheet to Another Using VBA in Excel Here’s an overview of the sample dataset we will be ...

Extract Data from One Sheet to Another Using VBA in Excel (3 Methods)

How to Find Duplicates in Two Different Excel Workbooks (5 Methods)

Jul 6, 2024

Let’s assume we have two different datasets with a common field (Employee Name) in two different sheets in two workbooks. The first dataset is in ...

How to Find Duplicates in Two Different Excel Workbooks (5 Methods)

Excel VBA: Copy Dynamic Range to Another Workbook

Nov 11, 2025

Different scenarios may arise while using Excel. You may need to copy a range from one workbook to another. We hope, after finishing the article you ...

Excel VBA: Copy Dynamic Range to Another Workbook

Applications of Absolute Structured References in Excel Table Formulas

Nov 11, 2025

In this tutorial, we will explain the applications of absolute structured references in Excel table formulas. One thing you should know is that ...

How to Extract Text after a Specific Text in Excel?

Jun 20, 2024

Method 1 - Using Flash Fill Feature to Extract Text after a Specific Text Steps: Enter the product name, Apple, from the code in ...

How to Extract Text after a Specific Text in Excel?

How to Count Columns until the Value is Reached in Excel – 2 Steps

Aug 11, 2024

The dataset showcases Sales Person , Target and units sold in Quarter-1. To calculate how many months they took to achieve their Target: ...

How to Count Columns until the Value is Reached in Excel – 2 Steps

How to Calculate Running Total in One Cell in Excel (5 Ways)

Nov 11, 2025

A lot of times we need to find out the Running Total in our Excel datasheet instead of the Grand Total. It’s also desired that the running total gets ...