11. Data Mining with Advanced Filter

In This Chapter

Replacing a Loop with AutoFilter

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 Rather Than Unique Records Only

Next Steps

Read this chapter.

Although very few people use Advanced Filter in Excel, it is a workhorse in Excel VBA.

I will estimate that I end up using one of these filtering techniques as the core of a macro in 80 percent of the macros I develop for clients. Given that Advanced Filter is used in less than 1 percent of Excel sessions, this is a dramatic statistic.

So even if you hardly ever ...

Get Excel® 2013 VBA and Macros 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.

Start your free trial