11Data Mining with Advanced Filter
IN THIS CHAPTER
Advanced Filter Is Easier in VBA Than in Excel
Using Advanced Filter to Extract a Unique List of Values
Using Advanced Filter with Criteria Ranges
Using “Filter in Place” in Advanced Filter
The Real Workhorse: xlFilterCopy with All Records Instead of Unique Records Only
Case Study: Utilizing Two Kinds of Advanced Filters to Create a Report for Each Customer
Advanced Filter Is Easier in VBA Than in Excel
The arcane Advanced Filter command is so hard in the Excel user interface that it is pretty rare to find someone who enjoys using it regularly. I predict that Microsoft will totally rework this command for Excel 2005 to make it easier ...
Get VBA and Macros for Microsoft Excel now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
