Info

Advanced Filter Is Easier in VBA Than in Excel 207

Using Advanced Filter to Extract a Unique List of Values 208

Using Advanced Filter with Criteria Ranges 215

Case Study 218

Case Study 220

Using "Filter in Place"in Advanced Filter . . .225

The Real Workhorse: xiFiiterCopy with All Records Instead of Unique Records Only 226

Case Study: Utilizing Two Kinds of Advanced Filters to Create a Report for Each Customer 230

AutoFilters 233

Next Steps 234

■ Criteria: You can filter with or without criteria. Filtering with criteria is appropriate for getting a subset of rows. Filtering without criteria is still useful when you want a subset of columns or when you are using the Unique Records Only option.

■ Unique: You can choose to request Unique Records Only or all matching records. The Unique option makes the Advanced Filter command one of the fastest ways to find a unique list of values in one field.

Figure 11.1

The Advanced Filter dialog is complicated to use in the Excel user interface. Luckily, it is far easier in VBA.

Figure 11.1

The Advanced Filter dialog is complicated to use in the Excel user interface. Luckily, it is far easier in VBA.

0 0

Post a comment