2 Ways to Filter for a List of Items in Excel


0   0

Learn 2 ways to filter for a list of items in Excel. This video is a sample lesson from the Filters 101 Online Course.


I explain 2 techniques for filtering a column for multiple items:

1. Use the Add current selection to filter method.
2. Use a formula based approach using the COUNTIF function.

Click here to read the blog post: https://www.excelcampus.com/tips/filter-for-list/

Both of these techniques allow us to apply a filter to a single column for multiple criteria. If you have a long list of items to filter for (over 3), then method #2 using the COUNTIF function is a great way to go.

This method also allows us to quickly filter for the items that are NOT in the filter list. We can use this technique to apply filters to pivot tables or dashboards with slicers.

Please click the link below to learn more about the Filters 101 Online Course.


I also have a free video series on Excel Filters. Here are links to each video.

Video #1 - Overview of Filters: https://youtu.be/cB5koQvGwsA
Video #2 Keyboard Shortcuts for Filters: https://youtu.be/Z1_oq-uPUBU
Video #3 Multiple Column Filters: https://youtu.be/rgATdkyLey8

If you are new to Excel Tables, I have a video on Excel Tables for Beginners: https://youtu.be/fJnJTff4Na8

Published 11 months ago

Category Video  /  Videolar

Tagsexcel filters shortcuts list excel campus tutorials how to

View More