Filtering Data With FILTER
Return only the rows that meet your conditions dynamically.
What FILTER Does
The FILTER function returns only the rows of a range that meet a condition you set. Instead of manually hiding rows or copying matches, FILTER spills the matching rows automatically.
It is dynamic: when your data changes, the filtered output updates instantly. This makes it perfect for live reports that always show the current matches.
The FILTER Syntax
FILTER takes up to three arguments:
=FILTER(array, include, [if_empty])
- array is the range you want to return.
- include is a logical test that produces TRUE or FALSE for each row.
- if_empty is an optional value to show when nothing matches.
The include test must be the same height as the array so each row gets a TRUE or FALSE.
=FILTER(array, include, [if_empty])All lessons in this course
- What Spilling Means
- Filtering Data With FILTER
- Removing Duplicates With UNIQUE
- Handling the SPILL Error