FILTER
Array FormulasLearn the FILTER function for dynamic array filtering in Excel 365. Create auto-updating filtered lists without helper columns.
Syntax
FILTER(array, include, [if_empty])Parameters
arrayThe range or array to filter
includeBoolean array of same height (TRUE values are included)
if_emptyValue to return if no results (optional)
Examples
=FILTER(A2:C100, B2:B100>1000)Filter rows where column B > 1000
=FILTER(A:C, (A:A="Sales")*(B:B>100), "No results")Multiple criteria with custom empty message
=FILTER(A2:D100, (B2:B100=E1)+(C2:C100=E1))OR condition filter
Common Errors
#CALC! - No results (use if_empty parameter)
#VALUE! - Include array wrong size
Pro Tips
Use * for AND logic, + for OR logic in criteria
Results spill automatically
Combine with SORT for sorted filtered results
Related Functions
Need Help with FILTER?
Describe your specific use case and our AI will generate the perfect FILTER formula for you.
Generate FILTER Formula