FILTER
Filters a range of data based on criteria you define.
Lookup & ReferenceDynamic Arrays & LAMBDALookup & Matching EssentialsModern Excel Functions
What it does
Filters a range/array to only the rows that meet a condition (dynamic array).
Syntax
FILTER(array, include, [if_empty])
Arguments
array(range|array) — Range to filter.include(range|array) — TRUE/FALSE include mask.
Examples
Filter by region
Return Amounts where Region="EU".
FORMULA
=FILTER(B2:B6,A2:A6="EU","No rows")
RESULT
[spills]
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Region | Amount |
| 2 | EU | 10 |
| 3 | US | 7 |
| 4 | EU | 5 |
| 5 | EU | 15 |
| 6 | US | 3 |