This post will guide you how to filter your data by multiple criteria with Advanced Filter command in Excel.  How do I filter multiple columns in Excel.

Filter for Multiple Criteria

Assuming that you have a list of data in range A1:B6, and you want to filter requires complex criteria (such as: Product =”excel” and Version=”2010”), you can use the Advanced Filter command to achieve the result. Just do the following steps:

#1 create a separate criteria range on your worksheet.

#2 select the range that you want to filter based on the multiple criteria.

#3 go to DATA tab, click Advanced command under the Sort & Filter group. And the Advanced Filter dialog will open.

#4 select the criteria range created in step1 in the Criteria range text box. Click Ok button.

#5 you would notice that the results have been filtered out.