FILTER Function in Excel
Intermediate
Filters a range of data based on criteria you define.
Syntax
=FILTER(array, include, [if_empty])Example
Use Case
Filter a list to show only active employees.
Common Errors to Avoid
- Only available in Microsoft 365 and Excel 2021+
- Include array must return TRUE/FALSE and match array size
- #CALC! error if no matching results (use if_empty parameter)
Pro Tips
Use multiple conditions with * (AND) or + (OR) operators: FILTER(A:B,(A:A="X")*(B:B>10)). Always specify if_empty to handle no-match cases gracefully. Combine with SORT for sorted filtered results.
Need help with this formula?
Our AI Formula Generator can write this for you instantly.
Try AI Formula Generator →