How to filter multiple criteria in Excel

We can filter multiple criteria in Excel in different ways:

logical AND operator :

In this case, we use the multiplication operator (*) to return all the values ​​in the range of our array.

=FILTER(A6:D15,(A6:A15="Noah" )*(B6:B15=22))
answer is  {Noah,22,204,190}

logical OR operator :

In this case, we use the multiplication operator (+) to return all the values ​​in the range of our array.

=FILTER(A6:D15,(A6:A15="Noah" )+(B6:B15=22))

FILTER function

The FILTER function is one of the Lookup & reference functions of Excel.

It extracts all record from the database that matches the specified conditions.

FILTER Arguments 

FILTER(array, include, [if_empty])

FILTER function has 3 arguments:

• array you can enter the range of cells that make up the list or database.
• include is either the label of the column in double quotation marks.
• [if_empty] is the range of cells that contains the conditions you specify.

Related posts:

How to Use Chat GPT with Excel How to Anchor Cells in Excel Excel MINVERSE Function How to add 0 in front of number in excel