16:35
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.
1 Comment
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.
Suggested Videos
Do you ever need to generate a column of sample text? Do it in Excel pretty quickly.
This article series will show you how to utilise the Next Generation Cryptography (CNG) API from Microsoft for modern hashing and encrypting/decrypting in VBA.
In this part: Compatible with other environments.
