Macros & Excel VBA

Excel VBA to Find 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

Circumstances may arise when you need to use certain VBA codes that execute the operation from different worksheets, like you may need to use VBA ...

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

While working in Excel, we often have to work with a lot of worksheets in a workbook. Today I will be showing how you can pull data from multiple ...

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)

Are you working with some strings and need to split them into multiple parts? Then, you are in the right place. When working in Excel, we may need to ...

How to Use the INT Function in Excel – 8 Examples

  Excel INT Function: Syntax & Arguments Summary A decimal number can be represented as an integer using the INT function, which rounds ...

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)

We frequently add up a series of numbers, but in certain cases, we may need to sum the last 5 values in a row in Excel. In this article, I’ll discuss ...

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)

In real-life scenarios, you may deal with different sum operations in Excel, like the sum with multiple criteria, the sum entire column, the sum of ...

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

While dealing with a large dataset, adding many rows to your worksheet is necessary. But at the same time, you may need to hide some rows to give the ...

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