O'Reilly logo

Excel® 2013 VBA and Macros by Tracy Syrstad, Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required