SURPRISING Advanced Filter TRICK in Excel (You've Never Heard Of!)

Discover a hidden gem in Excel's Advanced Filter feature that can revolutionize how you handle data filtering. Watch and learn how to filter your Excel datasets not just by specific criteria but also by selecting only the columns you need.

🔍 What You'll Learn:
▪️ Basics of Advanced Filter: A quick refresher on what Advanced Filter in Excel does and how to set it up.
▪️ Filtering with Multiple Conditions: Learn how to use criteria such as date and keywords with wildcards to filter your data effectively.
▪️ Copying Filter Results to Another Sheet: Understand the process of transferring your filtered data to a different Excel tab.
▪️ Advanced Filter Trick Revealed: Discover how to filter and retrieve only specific columns from your dataset, an aspect often overlooked in Excel's Advanced Filter feature.

00:00 How to use Advanced Filter in Excel
00:50 How to Filter For MULTIPLE Conditions Using Advanced Excel Filter
02:05 Approximate Match - How to Use Wildcards in Advanced Filter
02:48 How to Copy the Advanced Filter Results to Another Sheet
04:20 Advanced FILTER TRICK

🚩Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#excel

[picturesfile]

Learning the Advanced Filter and the trick at the same time 😂

[kctechie]

Actually it's kind of encouraging to know there are so many features to learn that even someone as advanced as you and the friend from who you learned of this are still finding things you didn't know before.

[simoncox]

Yes! I’ve been using this for a few years in models I built for customers to help them analyse their management accounts lines without using a database, but it’s great you’ve shared it for others. Your demonstrations are always of the utmost clarity!

[billoneil]

Cool filter. And...when you use a macro to re-populate the results as the criteria changes....even better. I combined the 2 on a file I had built and it works great! Really helps simplify pulling data for large data sets...especially for those who are not all that schooled in excel.

[jellevanbrandt]

The subtle intelligence of these Microsoft engineers keep on amazing me.

[excelisfun]

Yes. That is a great trick that i have been teaching in my classes for years. Very handy with some ridiculously large Economic Data Sets that we get. Thanks for the fun video, as always Teammate : )

[shirleymoreman]

Yes 😊 I used to use it a lot for creating dependant dropdown lists (with VBA to set the criteria and refresh the query) I sort of discovered it by accident when I was trying to find a solution to a specific problem. Great video though and it's always great to learn new stuff no matter how much we think we know.

[DSAlthaus]

Wow! Just the kind of feature I've been looking for! Thanks. I've been working with spreadsheet products since Visicalc in the 1980's. I've done Lotus 1-2-3, and started with Excel 1.0. I'm not a newcomer, but I am in great need to update my skills since retiring at the end of 2015. It's a daunting task for this retired CPA.

[ulludacharkha]

Thanks Leila !
I have been using this since the year I actually happen to know about Advanced Filters (nearly 15 years back). It was a very handy feature, which helped me to create reports with only the required columns with Salary for different departments.
And the order for the columns can be different. Heading in the criteria needs to be different from the Data Headers, if the formula mentioned in criteria results in a false or true or other value.
Just for a change, I am feeling proud :)
Kanwaljit

[saids.]

Did not know about this hidden gem 💎

Yeah, the ADVANCED filter is almost as awesome as YOUR teaching ✨💪💯

[RaviChandran-btzv]

This is such a great USP about the Advance filter. Thank u so much for the great explanation

[richardhainsworth]

Great explanation Leila. I did know about the limited columns advanced filter trick - this is some img that Randy Austin does a lot within his VBA modules. It’s a great little trick that I have used a few times on work related tasks

[nbforme]

You can even set up your headings on the "filtered" page in a unique sequence. They don't have to be in the original order.

[MrXL]

Yes. It is one of the great uses of Advanced Filter... you are essentially filtering/sorting columns as well as filtering rows.

[paulbon]

It is a great trick! I've been using it for years. It makes the process faster if you assign range names to your DB and criteria. It makes it even faster if you record the filtering process as a macro and assign it to a button (which requires macro-enabled file of course, with all the security issues that come along). I also make the process dynamic to allow users to adjust themselves the criteria. It is a great tool.

[EmmanuelGidudu-kt]

I have grown into a mid-level expert from your videos. From Excel functions to VBA. thank you for the efforts to create content.

[shivamchopra]

No. You have no idea mam. How much you have helped people to grow and be successful in life. Many thanks to you

[silverfunnel]

Next Monday will be my day...thank you so much, Leila!

[krishnakishorepeddisetti]

Awesome...I didn't knew that this can be done with advanced filter....thanks for sharing leila

[harnishhoney]

Thank you Leila, this feature I never ever use earlier. Once again thank you for making stuff more easy.