<

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

Using Advanced Filters in Excel

Posted on
3,248 Points
48 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

CompTIA Network+

Prepare for the CompTIA Network+ exam by learning how to troubleshoot, configure, and manage both wired and wireless networks.

Usually, rounding is performed by some power of 10 - to thousands, hundreds, tens, or integer - or to one, two, or more decimals. But rounding can also be done to a power of two, say, 16 or 64, or 1/32 or 1/1024, even for extreme values.
Here is why.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month