Multiple filters in excel
In some situation, we need to filter multiple items out of n number of rows. In this situation, we can use advance filter option.
For an example, In an excel, we have list of country names and their land area. We need to filter out three countries. In this situation we can use advance filter, which provides the required output.
Click on the Data menu bar and under Sort & filter group select advanced filter option.
Advance filter dialog box will open. Under List range option, select the country name column and in Criteria range option, select the items to be filtered as shown in the image and then click OK.