In this video, we explain the Excel FILTER function. We start by explaining the basics of the FILTER function in Excel, and we show how to use it with Excel tables, then we show how to deal with errors that we might face when using the Excel FILTER function. Afterwards, we show how to use the Excel FILTER function with multiple criteria of AND or OR or a mix of both.
We Also show advanced tricks of using the Excel FILTER function, such as using a list of values as the criteria, and filtering by using a search keyword or text.

Watch our video explaining the SORT and SORTBY functions:
https://youtu.be/LlknBaeK-IE

Download Example files:
https://tinyurl.com/3czcrm3n

Time Stamps:
00:00 Introduction
00:31 FILTER function Basics
02:57 Using FILTER function with Excel tables
04:43 Dealing with errors when not finding filter results
05:23 Excel FILTER function with AND and OR criteria
10:23 Sorting the results using the SORT function
11:07 Selecting certain columns from the result of the Excel filter function
13:06 Using FILTER with a list of values as a criteria
14:58 FILTER function with a search keyword (Using wildcards with the FILTER function)
17:25 FILTER function in Excel – Availability
17:54 Conclusion

GET 15% OFF my Excel PowerPivot for beginners Course. Use discount code YOUTUBE15 at checkout (Limited time offer!)
https://tinyurl.com/4ayp2457

Follow us on Social Media:
Facebook: https://www.facebook.com/ExcelBonanza
Twitter: https://twitter.com/ExcelBonanza
Follow me on Linkedin: https://www.linkedin.com/in/abdelrahman-abdou-60240150/
Instagram: https://www.instagram.com/excelbonanza1
TikTok: https://www.tiktok.com/@excelbonanza
Telegram: https://t.me/ExcelBonanza
Website: https://www.ExcelBonanza.com

*****My online Excel Courses*****
https://www.excelbonanza.com/courses/

#filterfunction #filter #excelformula

Please take the opportunity to connect and share this video with your friends and family if you find it useful.