The Excel FILTER function is incredible! It enables you to extract a subset of your data based on criteria you specify. You can think of the FILTER function like a lookup that returns multiple matches.
The FILTER function can return a single column of data or multiple columns, and with a clever trick, which I’ll show you at the end, it can even return non-adjacent columns.
Download the Excel file here: https://www.myonlinetraininghub.com/excel-functions/excel-filter-function
0:00 Introduction to FILTER
0:31 FILTER function Syntax
1:03 FILTER with one criteria
2:03 FILTER with multiple AND criteria
4:31 FILTER with multiple OR criteria
6:26 Handing errors
7:56 FILTER and return non-contiguous columns
View my comprehensive courses: https://www.myonlinetraininghub.com/
Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/