Latest Blog Posts - Page 378 of 412

How to Do Advanced Sorting in Excel (9 Suitable Examples)

Jul 12, 2024

In this article, we will demonstrate several effective techniques for Advanced Sorting in Excel: Sorting from top to bottom. Sorting from ...

How to Do Advanced Sorting in Excel (9 Suitable Examples)

How to Sort Two Columns to Match in Excel (2 Simple Methods)

Jun 26, 2024

We will use a dataset that includes Items Produced in 2021 and Items Produced in 2022 of a company. Method 1 - Sort Two Columns to Match ...

How to Sort Two Columns to Match in Excel (2 Simple Methods)

How to Use VLOOKUP If Cell Contains a Word within Text in Excel

Jul 4, 2024

Here's an overview of using the VLOOKUP function to get a partial case-insensitive match within an array. How to Use VLOOKUP If a Cell ...

How to Use VLOOKUP If Cell Contains a Word within Text in Excel

How to Calculate Top 10 Percent in Excel (4 Ways)

Jul 4, 2024

Method 1 - Using Conditional Formatting to Calculate and Highlight the Top 10 Percent of Values Steps: Here's a dataset of salespersons with ...

How to Calculate Top 10 Percent in Excel (4 Ways)

How to Sort Alphabetically and Keep Rows Together in Excel: 4 Smart Ways

Jun 27, 2024

Method 1 - Employ Sort Feature 1.1 Sort Alphabetically Without Empty Column Steps: Select any of the column cells that you want to sort. Sort ...

How to Sort Alphabetically and Keep Rows Together in Excel: 4 Smart Ways

How to Swap Rows in Excel (4 Easy Ways)

Jun 16, 2024

For this tutorial, we'll use the following table as our dataset. Our goal is to swap the rows of the table using 4 different methods. ...

How to Auto Sort Multiple Columns in Excel (2 Useful Methods)

Jul 22, 2024

We have made a dataset named Dataset of Sales. It has column headers Sales Rep. and Sales. Method 1 - the Using SORT Function We need to ...

How to Auto Sort Multiple Columns in Excel (2 Useful Methods)

How to Sort Multiple Columns in Excel Independently of Each Other (2 Easy Ways)

Jul 15, 2024

We have a dataset of fruits with their delivery information and quantities. We are going to sort those columns independently. Method 1 - ...

How to Sort Multiple Columns in Excel Independently of Each Other (2 Easy Ways)

How to Lookup with Multiple Criteria in Excel (2 Easy Ways)

Jun 30, 2024

Consider the following dataset. We have the Employee IDs, Employee Names, Joining Dates, and Salaries of a company. We will lookup values with ...

How to Lookup with Multiple Criteria in Excel (2 Easy Ways)

How to Filter Cells with Formulas in Excel – 2 Methods

Aug 10, 2024

This is an overview. Method 1 - Using the FILTER and the ISFORMULA Functions to Extract Cells Containing Formulas In the datset below, ...

How to Filter Cells with Formulas in Excel – 2 Methods

How to Filter Multiple Columns Independently in Excel (5 Methods)

May 27, 2024

The dataset shows 10 delivery products of a company. It mentions the product ID, product name, quantity, delivery location, order date, and shipping ...

How to Filter Multiple Columns Independently in Excel (5 Methods)

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

Aug 6, 2024

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 UCASE Function in Excel (4 Examples)

How to Filter Multiple Columns Simultaneously in Excel: 4 Methods

Jul 4, 2024

In the following dataset, you can see the ID Number, Sales Rep., Location, Product, and Sales columns. We'll filter the results by multiple columns. ...

How to Filter Multiple Columns Simultaneously in Excel: 4 Methods

The Excel VBA MsgBox Function – MsgBox Types, Constants and Return Values

Aug 14, 2024

Download Practice Workbook Download the following workbook. Excel VBA MsgBox Function.xlsm The MsgBox Function in Excel ...

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

Aug 5, 2024

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 ...