HDTutorial
EN
How to Set Up an Excel Advanced Filter

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Set Up an Excel Advanced Filter

116,899 views October 26, 2013 4:26

Watch on YouTube
ChannelContextures Inc.

Description from the creator

contextures.com/xladvfilter01.html Visit this page for details, and to download the sample file.

It's easy to filter a list with the builtin AutoFilter feature -- just right-click on a cell, click Filter, then click Filter by Selected Cell

If the list did not already have drop down arrows in the headings cells, those are added automatically, when the AutoFilter is applied.

You can select a criteria in each cell of the list, to see the records that meet all of the criteria. For example, see all the orders with a specific customer AND a specific product.

However, with an AutoFilter, there is a limitation -- you can't see all the orders with a specific customer OR a specific product.

To filter a table for one set of criteria OR another, use an advanced filter. This short video shows you the steps.

About this tutorial

Contextures Inc. published this 4:26 video tutorial on October 26, 2013. It has been watched 116,899 times on YouTube.

Duration
4:26
Published
October 26, 2013
Views
116,899
Likes
239

Tags

Share

Further reading

  • How to Set Up an Excel Advanced Filter - Contextures Blog contexturesblog.com

    Poor Advanced Filter! It’s hidden in a dark corner of the Ribbon’s Data tab, overshadowed by its better known, and more popular sibling, AutoFilter. Sometimes, though, it's worth the extra effort to use an Advanced Filt…

  • Excel Advanced Filter – how to create and use ablebits.com

    In Excel 2003, click the Data menu, point to Filter, and then click Advanced Filter…. The Excel Advanced Filter dialog box will appear and you set it up as explained below. 4. Configure the Advanced Filter parameters. I…

  • Advanced Filter in Excel - Easy Excel Tutorial excel-easy.com

    2. Click any single cell inside the data set. 3. On the Data tab, in the Sort & Filter group, click Advanced. 4. Click in the Criteria range box and select the range A1:D2 (blue). 5. Click OK. Notice the options to copy…

This tutorial in other languages