Resources > Formula Help
How Do I Use FILTER in Excel?
Last Updated: June 2026
Quick Answer
FILTER returns rows or columns that meet criteria. It is one of Excel's most useful dynamic array functions.
=FILTER(A2:D100,B2:B100="East")
FILTER Syntax
=FILTER(array, include, [if_empty])
- array: the data to return
- include: the condition to test
- if_empty: optional message if nothing matches
Multiple Criteria
=FILTER(A2:D100,(B2:B100="East")*(C2:C100="Complete"))
The asterisk works like AND logic.
Custom Message If Nothing Matches
=FILTER(A2:D100,B2:B100="East","No results")
Need Help With Dynamic Arrays?
FILTER can make reports much more powerful, but complex criteria can get tricky fast.
