Across Sheet Advanced Filtering in Excel

Welcome to Excel Jet Consult blog post. In this post we will learn how to use the ADVANCED filter in Excel. Succinctly, filter allows users to narrow down the data they intended to see after a particular point in time.

The ADVANCED filter button is located in the Sort & Filter group of the Data tab

Note, the data we want to filter is located in the Sales Report sheet while the Filter criteria is located in the Filter Criteria sheet. See below

We want to filter the data in the Sales Report sheet based on the following criteria: Connor Rulibeth, Lagos, Beverages and Revenue that is greater than or equals to 5000 and less that or equal to 20000

To use the ADVANCED filter: Click inside the data and click on ADVANCED in the Sort & Filter group

The List range automatically get selected because we clicked inside the data initially

Next, click inside the Criteria range and proceed to the Filter Criteria

Select all the criteria (cells A1:E2)

Click OK. The data has been filtered based on the specified criteria as seen in the caption below

I hope you enjoyed the tutorial

Posted in Blog.

Leave a Reply

Your email address will not be published. Required fields are marked *