FILTER function in Excel

FILTER returns rows that meet a condition (spills).

Syntax

=FILTER(array, include, [if_empty])

Argument	Required?	What it is
array	Required	The range or array to work on.
include	Required	A TRUE/FALSE test with one result per row, such as B2:B20="North".
if_empty	Optional	What to return when nothing matches, such as "None". Without it, no match gives #CALC!.

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

From the lesson FILTER Function.

Type the formula yourself and get it graded instantly, no Excel needed.

FILTER returns rows that meet a condition (spills).

=FILTER(array, include, [if_empty])

Argument	Required?	What it is
array	Required	The range or array to work on.
include	Required	A TRUE/FALSE test with one result per row, such as B2:B20="North".
if_empty	Optional	What to return when nothing matches, such as "None". Without it, no match gives #CALC!.

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

From the lesson FILTER Function.

Type the formula yourself and get it graded instantly, no Excel needed.