Home » Science & Technology » Excel FILTER Function + Trick to Rearrange Column Order

Excel FILTER Function + Trick to Rearrange Column Order

Written By MyOnlineTrainingHub on Thursday, Oct 14, 2021 | 08:00 AM

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

Disclaimer:
All images, musics and videos copyright are belong to their respective owners. We just put embed contents from Youtube.com and do not host any content in our server. These content(s) may be protected by copyright law or other laws regarding intellectual property of the United States or other countries. Downloading file(s) on this site is just for review purpose. If you love the song, please support the artists by buying the original CD/Cassette or buying the song from iTunes.