Excel Advanced Filter Criteria AND Conditions

Video demonstrates how to use the Advanced Filter in Ms Excel for a scenario that requires the data to meet all of the criteria outlined in a question. There are three conditions, all of which need to be met in order for the relevant rows to be displayed. In the scenario, there are 100 rows of data, the data has headings/field names/column names on row 1. Three of the headings are used to set up the Criteria range and the relevant criteria values are then added. When the Advanced Filter is activated, it looks for a List range and a Criteria range - users are encouraged to check that both are correct before proceeding. Near the end of the clip, the query is executed and the rows that emerge (are displayed) are checked to ensure that they meet the criteria outlined in the question.