<

Using Advanced Filters in Excel

Posted on
3,249 Points
49 Views
2 Endorsements
Last Modified:
Experience Level: Beginner
16:37
This Micro Tutorial will demonstrate how to use advanced filters in Microsoft Excel. These filters are commonly used in real-world client projects for a reporting dashboard.
2
1 Comment

Expert Comment

by:LeeTownsend
The hint of using the apostrophe instead of the = sign at time ~5:00 saved my hide.  I needed exact matches so ME didn't give me also MET in a criteria table (actually an Excel Table).  When I tried   ="=ME", the Table of criteria I was making activated the Totals row.  Chaos ensued.  Using the apostrophe did not have that problem.  So, thank you very much for the hint.  Note that I was creating the Table using VBA.   I can now move on in my project.
0

Featured Post

Become a Certified Penetration Testing Engineer

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

Do you know how to convert CSV to multiple VCF formats? Are you searching for a hassle-free solution to import .csv file contacts into .vcf files? Get an optimum solution here to export Excel or CSV files to vCard or VCF formats! Read more to know t…
Charts are easy to insert manually but sometimes we need to automate the chart insertion and most of the people find it difficult to control the chart creation and its properties via VBA  In this article, we will learn about how we can use VBA to in…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month