Excel VBA help says that if you do not specify a criteria range, then no criteria is used. This is not true in Excel 2003—if no criteria range is specified,the AdvancedFilter inherits the CriteriaRange from the prior AdvancedFilter.You should include CriteriaRange:="" to clear the prior value.

Using Formula-Based Conditions to Return Above-Average Records

The formula-based conditions formula criteria are cool, but are a rarely used feature in a rarely used function. There are some interesting business applications that use this technique. For example, this criteria formula would find all the above-average rows in the dataset:

0 0

Post a comment