All functions / Dynamic arrays

FILTER

Keeps only the rows that meet a condition. The result spills.

Syntax

=FILTER(array, include, [if_empty])

Arguments

• array: The data to filter.
• include: A TRUE/FALSE test for each row, e.g. C2:C20>100.
• if_empty (optional): What to return when nothing matches.

Example

=FILTER(A2:C20, B2:B20="East") → Only the East rows

Practise it

• FILTER: rows that match