FILTER Function in Excel
Learn how to use the FILTER function in Excel, understand the syntax and common use cases, and let ExcelGPT adapt the formula to your real workbook structure.
FILTER(array, include, [if_empty])arrayRequiredThe range or array to filter.
includeRequiredThe logical test that determines which rows or values to return.
if_emptyOptionalOptional value to return when no results match.
Examples
=FILTER(A2:D100, C2:C100="Active", "No matches")Returns all rows where the status column equals Active.
=FILTER(A2:F500, F2:F500>1000)Returns only the rows where the amount exceeds 1000.
Common mistakes
Check the argument order, data types, and references used in FILTER.
Review whether ranges, blank cells, error values, or dynamic results are affecting the formula.
Validate the formula on a few sample rows before scaling it across the workbook.
Related functions
Need a variant of this formula?
Describe your workbook structure and ExcelGPT can generate a version tailored to your real columns, ranges, and edge cases.