<

Watch Using Advanced Filters in Excel

Posted on
3,250 Points
50 Views
2 Endorsements
Last Modified:
Published
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
Obtaining and using time zones in Windows is not simple. It involves API calls and reading the Registry. Some information is localised, and some is not. Here you will find a complete set of functions that wraps the difficult steps, eases common task…
The Indian number format for currency has groups of two and three digits. The native Format function of VBA cannot handle this if Windows is set for a Western localisation. Thus, a custom method must be applied. Here it will be shown how to use dyna…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month