Excel Advanced Filter Archives

How to Use Auto Filter and Advanced Filter in Excel

Nov 11, 2025

Today, we will discuss how to use Auto Filter and Advanced Filter in Excel. The Auto Filter is the default filtering option in Excel. It allows users ...

How to Use an Advanced Filter for a Date Range in Excel – 2 Methods

Aug 2, 2024

The dataset showcases the sales quantity of electronic products on different dates in January, February and March 2022. Method 1- Use the ...

How to Use an Advanced Filter for a Date Range in Excel – 2 Methods

How to Use Advanced Filter with Wildcard in Excel

Nov 11, 2025

In this article, I will show you how to use the Advanced Filter with Wildcard in Excel. As we know, sometimes we need to use the Excel Advanced ...

How to Use Advanced Filter with Wildcard in Excel

How to Remove an Advanced Filter in Excel – 5 Methods

Aug 11, 2024

The dataset represents a duty roster. Advanced Filters were applied. To know if a dataset is Advanced filtered, look at the row index numbers. If ...

How to Remove an Advanced Filter in Excel – 5 Methods

How to Use Advanced Filter to Exclude Blank Cells in Excel (3 Easy Tricks)

Jul 18, 2024

What is Advanced Filter in Excel? Most of us are familiar with the regular Filter option in Excel. However, the regular Filter has some limitations. ...

How to Use Advanced Filter to Exclude Blank Cells in Excel (3 Easy Tricks)

How to Use Advanced Filter for Unique Records Only in Excel

Jul 12, 2024

We have a dataset that contains multiple identical entries. We want to remove identical entries and keep one of them. Use an Advanced ...

How to Use Advanced Filter for Unique Records Only in Excel

How to Use Advanced Filter to Copy Data to Another Sheet in Excel

Jul 28, 2024

In this article, we will demonstrate two methods to apply the Advanced Filter to copy data to another sheet in Excel. In the first method, we will ...

How to Use Advanced Filter to Copy Data to Another Sheet in Excel

How to Apply the Advanced Filter to Copy to Another Location in Excel

Nov 11, 2025

Advanced Filter is one of the most useful and advantageous features of Excel that’s used pretty often to copy one range of cells from one location to ...

How to Apply the Advanced Filter to Copy to Another Location in Excel

Excel Advanced Filter: Apply “Does Not Contain” (2 Methods)

May 16, 2024

The sample dataset contains the Product Name, Product Category, and the shipping Address of customers. We will use Excel Advanced Filters does not ...

Excel Advanced Filter: Apply “Does Not Contain” (2 Methods)

How to Use an Advanced Filter If the Criteria Range Contains Text in Excel – 5 Methods

Aug 13, 2024

This is the sample dataset. Method 1 - Using an Advanced Filter for a Cell That Contains Unique Text Values The dataset ...

How to Use an Advanced Filter If the Criteria Range Contains Text in Excel – 5 Methods

Excel Advanced Filter Not Working (2 Reasons & Solutions)

Jun 19, 2024

What Is the Advanced Filter in Excel? We can use the Advanced filter to perform complex filtering in Excel. For example, you can filter data ...

Excel Advanced Filter Not Working (2 Reasons & Solutions)

Advanced Filter with Criteria Range in Excel (18 Applications)

Jun 16, 2024

Method 1 - Using the Advanced Filter Criteria Range for Number and Dates Column B to Column E in the sample dataset represents sales data. We will ...

Advanced Filter with Criteria Range in Excel (18 Applications)

How to Use the Advanced Filter in VBA (A Step-by-Step Guideline)

Jul 4, 2024

In this article, we'll demonstrate how to use Excel's Advanced Filter in VBA. Excel Advanced Filter Overview Advanced Filter is a tool ...

How to Use the Advanced Filter in VBA (A Step-by-Step Guideline)

How to Create Dynamic Advanced Filter in Excel: 2 Applications

Jun 21, 2024

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 Create Dynamic Advanced Filter in Excel: 2 Applications

Advanced Filter with Multiple Criteria in Excel (15 Suitable Examples)

Jun 26, 2024

Example 1 - Advanced Filter for AND Criteria Below is our sample dataset. We’re going to extract data for all devices made in the USA and devices ...