Hi Richard, if you set up the Criteria Range above the List, with all the Headers, how come Excel doesn't return a blank filtered list instead, since across 1 row, it uses the AND condition. If you don't include a condition for every column, shouldn't it say Store=Buffalo for example AND no information in Profit) - but since we have information in every profit cell, there is no record that has no profit, i.e. there is no record that satisfies both of those conditions, for the filtered list?