You will notice that these formulas produce logic answers of TRUEor FALSEonly.
When using the formulas to specify the filtering criteria, the cells above the formula
cells in the criteria range do not need any label or heading; however, those cells must be
included when specifying the criteria range in the Advanced Filter dialog box. The result
produced by filtering through the above two formulas will yield four funds that have
above average five-year returns and below average expense ratios.
Although advanced filtering using formulas can be powerful, the expanded options
in the AutoFilter ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.