11. Data Mining with Advanced Filter

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, Video Enhanced Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.