Excel FILTER Function + Trick to Rearrange Column Order
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 non-adjacent 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 non-contiguous columns
View my comprehensive courses: https://www.myonlinetraininghub.com/
Connect with me on LinkedIn: / myndatreacy
Watch video Excel FILTER Function + Trick to Rearrange Column Order online without registration, duration hours minute second in high quality. This video was added by user MyOnlineTrainingHub 14 October 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 157,937 once and liked it 4.7 thousand people.