Macros & Excel VBA

Using Excel VBA to Find a Value in a Column – 6 Examples

The sample dataset contains Product ID, Brand, Model, Unit Price, and Order ID. You want to find an Order ID associated with a Product ID. ...

Use Excel VBA VLOOKUP to Find Values in Another Worksheet

In this article, we will demonstrate how to use the Excel VBA VLOOKUP in another worksheet. Suppose we have the dataset below, stored in the sheet ...

How to Pull Data from Multiple Worksheets in Excel (4 Quick Ways)

We have three worksheets in a workbook. They contain the sales records of some items over January, February and March, respectively. We'll pull data ...

How to Use VBA UCASE Function in Excel (4 Examples)

Excel provides several VBA functions that can be used while writing a macro or to define your own function to perform your desired tasks. In this ...

How to Use VBA SPLIT Function in Excel (10 Ideal Examples)

How to Launch the VBA Editor in Excel If you don’t see the Developer tab, enable the Developer tab. Select the Developer tab and click on ...

How to Use the INT Function in Excel – 8 Examples

The Excel INT Function: Summary A decimal number can be represented as an integer using the INT function, which rounds it down to the lowest ...

How to Create Dynamic Advanced Filter in Excel: 2 Applications

Method 1. Dynamic Advanced Filter with a Keyboard Shortcut Created by Using Excel Macros Steps: In the Code section from the Developer tab, you ...

How to Apply Multiple Filters in Excel: 6 Methods

Before going to the steps, consider the following dataset. Here, the Names of 15 Sites are given along with their Category. Furthermore, the Visits ...

How to Sum Last 5 Values in a Row in Excel (5 Handy Approaches)

Download the Practice Workbook Finding Sum of Last 5 Values.xlsm 5 Simple Methods to Sum Last 5 Values in a Row in Excel We have a ...

How to Compare Two Strings for Similarity in Excel: 6 Methods

Method 1 - Using Highlight Cells Rules Feature Steps: Select all the cells from B5 to C10. Go to the Home tab and click on Conditional ...

How to Sum Every Nth Column in Excel (3 Methods)

We have a sample table of Products and revenue of the items for each month from January to June. The revenues for each month are stored in separate ...

How to Count Visible Rows in Excel (3 Suitable Methods)

Here's the dataset we'll use to count rows. We have a table with three columns; Books, Genre, and Author. There are 10 books listed. To show ...

How to Find Unique Values from Multiple Columns in Excel (5 Easy Ways)

We have a record of student IDs and names. We want to extract the unique values. Method 1 - Extract Unique Values from Multiple Columns ...

How to Separate Text and Numbers in Excel (6 Suitable Ways)

  Let us have a look at this data set. We have the Combined Data of some students. We have two separate columns, C and D, where we want to ...

Excel Formula to Copy Cell Value to Another Cell

In this dataset, there are five people’s First Names, Last Names and Ages. Using Excel formulas, we will copy cell value from this dataset to another ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo