Using the AutoFilter function, you filtered a table by setting a criterion in one column (e.g., Customer name). But now you want to further constrain the (already filtered) data sets by filtering them through the addition of another filter in a different column.
In this learning module “Excel criteria”, you will discover how to filter a table by applying filter criteria in more than one column.
Excel criteria: HOW DOES IT WORK?
Using the AutoFilter function, you want to filter a table by applying criteria in more than one column, which, in effect, produces an AND operation between the criteria.
An AND operation between two filter criteria (two columns), for example, implies that the data sets that finally appear are those for which both criteria have been fulfilled.
To do this, first activate the AutoFilter function by clicking the button on the Data tab, in the Sort & Filter group.
Then click the filter arrow at the top of the customer column. The filter criteria menu appears. In the lower part of this menu, deactivate the Select All option and select just the customer name: Banner Car Parts. Conclude by clicking OK. The first filter has now been applied.
The second criterion will be added in the same fashion. Click the filter arrow at the head of the Shipping column. Here, too, deactivate the Select All option, and then activate Express. Conclude by clicking OK.
At any time, you can add additional filtering in other columns.