Excel FILTER Function

Syntax

=FILTER(array, include, [if_empty])

Description

Allows you to filter a range of data based on criteria you define.
Looking for ready templates?
Example file for this function coming soon — meanwhile: 9,000+ ready templates.

Related Functions