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: 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/