support.microsoft.com
FILTER Function
Official Microsoft reference for filtering dynamic arrays with criteria.
- Sites
- Free
What it is
Rather than using AutoFilter to hide rows, this dynamic array function returns only the rows that meet your criteria into a separate spill range, updating automatically when the source data changes. Microsoft's reference covers single and multiple conditions, what to return when no matches are found, and combining it with other array functions.
At a glance
- Source
- support.microsoft.com
- Category
- Official Microsoft
- Cost
- Free
