Excel Tips - FILTER Function Basics and Multiple Criteria with Column Select
Hey team,
This video will show you how to use the FILTER function in Excel. We start off with the basics but there are examples of adding "and" and "or" criteria to the filter as well. At the end I also show how to return only the columns you want to see.
Chapters:
0:00 Introduction
0:38 FILTER Basics
1:29 FILTER with AND Criteria
2:43 FILTER with OR including AND Criteria
4:17 FILTER with OR including multiple AND criteria
5:05 Choose Columns to Include in Filter Results