If you have an Excel sheet on which you would like to filter on several criteria, you have three different ways, depending if you want to filter on one, two, or multiple criteria, in which case you need to use the advanced filter Excel in addition with Excel wildcards to refine the filters.
It is possible to use multiple filters in Excel, with Autofilter, in order to have advancedfilter applied to an open spreadsheet, and find the Excel match multiple criteria on one or more columns.
To be able to do an Excel filter more than 2 criteria, you have to create another column with the exact same header as the column that you want to filter - in our example, column is name - and put one search criteria by line below. All selection criteria will be applied as an OR - meaning, results will match any of them.
Then, select the column you want to filter, select the Data menu => Advanced option in Sort & Filter box, click on Criteria range icon, and select the criteria cells - not the whole column, only the criteria data starting with same column header as the data to filter.
And voilà ! See below example, a list of hotel has been filter to all hotels from either Holiday Inn, Crowne Plaza, Radisson, or Novotel, with an advanced filter Excel 2013, resulting in an Excel custom autofilter more than 2 criteria, also called an Excel advanced filter multiple criteria one column as the different criteria are applied simultaneously on the same column.
The Excel custom filter more than 2 criteria contains will result in only the entries containing any of the filters being displayed.
About Yoann Yoann is an international business consultant.
He helps businesses implementing their international projects, facilitating exchanges between various cultures, specialties, streams, and technologies.
He thrives in designing, improving, adapting, innovating, and making solutions work, to satisfy clients. He created www.ybierling.com to share his expertise.
He worked more than 10 years in international business development, global supply chain perfection, financial optimization, SAP ERP project deployment, and Web based business support for various industries, such as logistics, cosmetics, consumer goods, beauty care, or fashion, in more than 30 countries around the globe.