FILTER Function

FILTER returns only the rows that meet a condition, and the answer spills into the cells below. Give it the range to return and a test such as B2:B10="North". If nothing matches you get an error: give FILTER a third argument, if_empty, such as "None", or wrap it in IFERROR.

Example: =FILTER(A2:A10,B2:B10="North") lists the products sold in the North.