Dynamic Arrays
Return multiple values and spill results automatically.
Quick Function Index
Jump to a letter, or search to filter within this category.
Filter
ExcelGoogle Sheets
Array The range of data you want to filter and return. This can be a single column or multiple columns, but it…
Filter
Syntax
=FILTER(array, include, [if_empty])
Syntax description
Array
The range of data you want to filter and return.
This can be a single column or multiple columns, but it must be a continuous range.
Include
One or more logical tests that return TRUE or FALSE for each row in the array.
Only rows where the condition evaluates to TRUE are included in the result.
[if_empty] (optional)
The value to return if no rows meet the condition.
If omitted, the function returns an error when no matches are found.
Popular Functions
Hand-picked function guides that work in both Excel and Google Sheets.