11. Data Mining with Advanced Filter
In This Chapter
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 ...