Show only few columns using FILTER function in Excel 365

The FILTER function is a versatile function that can help you selectively display only the columns you need. In this insightful video, you'll discover how to leverage the power of arrays with the FILTER function to extract precisely the columns you want, without the hassle of manual column hiding or formatting.

With this technique, you'll get precise control of how you want to display your data. No more wasted time sifting through irrelevant information or struggling to keep your spreadsheets organized. With the FILTER function's array-based capabilities, you can effortlessly extract the data that matters most, enabling you to present your findings with clarity and precision.

🕙 You can use these timestamps in case you are looking for something specific
00:00 - Introduction
00:38 - Writing a simple FILTER function
01:48 - Understanding arrays notation
02:39 - Displaying select columns using the FILTER function and arrays
04:02 - Using FILTER funciton and the SUM function tegether

▶️ Other videos that may interest you
How to use FILTER function in Excel
   • How to use FILTER function in Excel; ...  

How to use the CHOOSECOLS function in Excel?
   • How to use the CHOOSECOLS function in...  

✅ Subscribe to our Channel to level up your Excel skills faster
   / @analyticssuccess  

⬇️ Download the file used in the video
https://www.qling.net/11174/files/66c...

💻 Courses offered by us

Learn more about our Excel Masterclass course
https://yt.qling.net/excel-masterclass

Explore all courses
https://yt.qling.net/courses

📘 Download our E-Book on Excel Shortcuts (Windows and Mac)
https://yt.qling.net/excel-shortcuts

🗂️ Access all our templates and E-Books
https://yt.qling.net/templates-and-eb...

🤝 Connect with us

LinkedIn:   / qling1  
Facebook:   / learnatqling  
Instagram:   / learnwithqling  
Pinterest:   / learnatqling  
Get in touch: https://quiz.qling.net/get-in-touch/

#analyticssuccess