Advanced Filter in Excel

Microsoft Excel has wonderful feature called Advanced Filter. Through this filter you can easily filter with multiple criteria to get the output in different sheet or same sheet in different range.

We will start with below table to understand that how advanced filter works in excel. To achieve this follow the below steps.

Step 1:

Assuming that you have a table as shown in the below picture to put advanced filter in excel.

Advanced Filter

Step 2:

Before going to apply advanced filter, place an other table with criteria and typed as Car in that as shown in the below picture.

Criteria Range

Step 3:

Go to menu bar and click Data->Advanced like below picture.

Advanced Filter Menu

Step 4:

After clicked Advanced option from above, a pop-up window will appear as below picture.

Advanced Filter Window

Step 5:

After that, select list range in the excel sheet and select criteria range as mentioned in step 2. Finally select the Copy to another location range as shown in the below picture.