In this tutorial, you will learn how to use “contains” in Excel advanced filter in Excel.
One of Excel’s coolest features is the advance filter. AutoFilter cannot do many complex filtering operations that Advance Filter can. This article will demonstrate how to use Excel’s Advanced Filter if the criteria range contains text. For convenience, we’ll use a sample dataset that has the data elements Date, Name, Item, and Sales. We will extract data from this dataset for a number of intricate criteria.
Once ready, we’ll get started by utilizing real-world examples to show you how to use “contains” in Excel advanced filter in Excel.
Table of Contents
Use “Contains” in Excel Advanced Filter in Excel
Before we begin we will need a group of data to use “contains” in Excel advanced filter in Excel.
Step 1
First, you need to have a clean and tidy group of data to work with.
Step 2
In this example, we want find students names that contain the letter ‘n’. To do so, we can simply use the advance filter function in Excel. First we will select the criteria, then select ‘Data’ and select ‘Advanced’.
Step 3
We will then select the respective range to insert into the pop-up box.
Step 3
Once we are done, you will be able to use “contains” in Excel advanced filter in Excel.
