The Excel custom filter more than 2 criteria contains will result in only the entries containing any of the filters being displayed.
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.Īnd 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. All selection criteria will be applied as an OR - meaning, results will match any of them. range of values stored as text, right-click, and choose Paste Special, Multiply. 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. Switch over to wherever you need the symbol, whether in MS Word, Excel. Result filtered with two criteria 3 – Excel advanced filter multiple criteria one column
