Extract Specific Columns || Filter Function vs Advanced Filter || Simply Explained Part 2

This is the second part of the video on the filter function and advanced filter in Excel. The filter function is a dynamic array function; however, Advanced is not dynamic.

Please check out other videos on my channel and don't forget to comment, like, share, subscribe and click the bell icon so you'll get a notification when the next video is uploaded. Thanks!

Content
0:00 Intro
0:27 Filter Function
1:08 Extract data from a column
1:52 Nested Filter function
2:29 Extract data from multiple columns
3:16 XMATCH & ISNUMBER for Boolean values
5:30 Advanced Filter

Connect with me on:
👉Instagram and Facebook @youexceltutorials
👉Twitter @youexceltutor
👉LinkedIn @bunmisanusi

🎬Check these videos:

📢“the Lord will watch over your coming and going both now and forevermore” Psalm 121:8 (NIV)

#msexcel #youexceltutorials