Advanced
Lookup & Reference
FILTER
Returns only the rows of a range that meet a condition, automatically spilling the matching rows into neighboring cells.
Compatibility: Microsoft 365, Excel 2021+
Syntax
=FILTER(array, include, [if_empty])
Example
=FILTER(A2:C20,B2:B20="West")
When to Use It
Use FILTER to build a live, formula-driven filtered view of your data that updates automatically, instead of manually reapplying a filter each time the data changes.