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.
