Advance Filter in Excel

Data filter is best way to get and work with subset of data. In Excel there are two types of filters one is Auto filter which you can simply apply by using shortcut key “Ctrl+Shift+L”, and another one is Advance filter.

Filter will temporarily hide rows which not matching filter criteria and display only subset which you required.

Auto filter: for simple criteria (e.g. column containing particular value or number)

Advance filter: Complex criteria (Let’s look at one example how advance filter works.)

Step 1 : Add some rows above your data.
Step 2 : Copy table headers and paste in top row.
Step 3 : Writer your criteria, make sure you have at least one blank row between criteria and your data.
Step 4 : Click on Data --> Advance filter.
Step 5 : Add table and criteria range in the advance filter window.
Step 6 : Click ok to see final outcome.

Hope above example help you understand advance filter for practice you can download a file as below.

 

for download this file for practice click on excel symbol.

Please use comment section to provide your feedback or to ask questions.