Monday, 2 September 2013

Multiple filters in excel

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.

Advance Filter

Advance Filter

No comments:

Post a Comment

Creative Commons Licence
BLOG by Suresh is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
Based on a work at
Permissions beyond the scope of this license may be available at