Excel criteria: Filtering criteria in more than one column (AND)


YOUR OBJECTIVE

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.

The displayed table rows fulfill both excel criteria: 

 

HINT

At any time, you can add additional filtering in other columns.

 

Did you like it? Then share it or sign up!

You can share this article with your friends or sign up for our newsletter for further information.

Leave a comment

Connect with Facebook

*

Kein Banner zum Anzeigen