Applying Advanced Criteria Filter
There is an Excel file that teaches how to perform the Applying Advanced Criteria Filter operation.
Excel Source: Applying Advanced Criteria Filter
This workbook applies advanced criteria filtering on 58 rows with unmatched records listed on a separate sheet.
Hope it is useful.