Define named ranges to reference your advanced filter criteria and any destination ranges for filtered data.

定义命名范围为已筛选数据引用你的高级筛选条件和任意目标范围.

互联网

Table 5. Advanced filter properties.

列表5. 高级筛选属性.

互联网

Apply an advanced filter using a previously defined named range.

使用前面已定义的命名范围应用高级筛选.

互联网

Listing 8. Use advanced filter.

列表8. 使用高级筛选.

互联网