If the criteria range for the Advanced Filter includes a row with no criteria,the entire record set will be returned because nothing is constraining the records.

Question

Quizplus · Accepted Answer

When there is no criteria in a row of the criteria range, it means there is no filter applied to that particular field/column. Therefore, all the records will be returned, as there is no constraint on the records.

If the Criteria Range for the Advanced Filter Includes a Row