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.
Raw data set to filter on multiple criteria
1 – Excel 2013 filter on one criteria
The first and easiest way, to filter on one or maximum 2 criteria, is to apply a filter in menu Data=> Filter.
Apply standard filter
With filter applied, on the column on which you want to filter, click on the arrow, and, in Search field, enter the string you are looking for :
ABCfor entries containing ABC,
ABC* for entries starting with ABC,
*ABC for entries ending with ABC.
Apply single filter, or open menu to apply 2 filters
2 – Excel 2013 filter on two criteria
With filter applied, on the column on which you want to filter, click on the arrow, and, in Text Filters menu, select Containsoption.
In the open box, you can then enter one or two criteria – if you select OR, both will be applied. If you select AND(by default), only entries meeting the two criteria will be selected.
Custom single or double filterResult filtered with two criteria
3 – Excel 2013 filter on multiple (more than two) criteria
To be able to filter on more than two 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 Datamenu => Advancedoption 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.
Creation of a filter criteria listSelection of the list to filter with multiple criteriaAdvanced filter for multiple criteria menuMultiple criteria selectionMultiple criteria selected for advanced filterList filtered with multiple criteria
