Excel’s FILTER function is incredible. It enables you to extract a subset of your data based on criteria you specify. You can think of it like a lookup that returns multiple matches. It 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 nonadjacent columns.

Download the Excel file here: https://www.myonlinetraininghub.com/e...

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 noncontiguous columns

View my comprehensive courses: https://www.myonlinetraininghub.com/

Connect with me on LinkedIn:   / myndatreacy