FILTER Function in Excel: Syntax, Examples and Free Practice
FILTER is an Excel Lookup & Reference function. Returns only the rows of a range that match a condition.
FILTER syntax
Arguments
array: The range or array to evaluateinclude: The condition used to decide which rows to keepif_empty: What to return if no results are found (optional)
When to use FILTER
FILTER is used to pull matching data from one part of a workbook into another.
Practice FILTER online, free
Open the live Excel-style spreadsheet and try FILTER yourself. No Excel install or sign-up needed to start.
Practice FILTER now →Watch: FILTER in Excel
Learn more
Read the tutorial: FILTER with multiple conditions.
More Lookup & Reference functions
Frequently asked questions
What does the FILTER function do in Excel?
Returns only the rows of a range that match a condition.
What is the syntax of FILTER in Excel?
The syntax is =FILTER(array, include, [if_empty]). array: The range or array to evaluate; include: The condition used to decide which rows to keep; if_empty: What to return if no results are found (optional).
Where can I practice FILTER online for free?
Open the free live spreadsheet on Cellgrids and try FILTER yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Lookup and Reference functions · Excel case studies · Excel tutorials · Excel shortcuts