Excel FILTER Function incl. Trick to Rearrange Column Order

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: www.myonlinetraininghub.com/excel-functions/excel-…

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: www.myonlinetraininghub.com/

Connect with me on LinkedIn: www.linkedin.com/in/myndatreacy/