Latest Blog Posts - Page 546 of 587

How to Find Duplicates in Excel (All Criteria Included)

Jul 24, 2024

⏷1. Using Conditional Formatting to Find & Highlight Duplicates in Excel ⏵1.1. Highlighting Duplicates in Excel with Duplicate Values Command ...

How to Find Duplicates in Excel (All Criteria Included)

How To Search Multiple Items in Excel Filter (2 Ways)

Apr 25, 2024

We have a simple table having a few random Persons from different Countries and their respective Favorite Sports and Favorite Player. We ...

How To Search Multiple Items in Excel Filter (2 Ways)

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 Use VBA DIR Function in Excel (7 Practical Examples)

Nov 11, 2025

The DIR function in VBA mainly shows you the directory or the files from a given folder. It can also return the first file with this function. This ...

How to Use VBA DIR Function in Excel (7 Practical Examples)

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