FILTER Formula Generator
FILTER returns rows from a range that meet specified conditions. It's like AutoFilter but as a formula — the results update automatically when your data changes.
Syntax
=FILTER(range, condition1, [condition2], ...)Try it — generate a FILTER formula
Examples
Filter sales over $1000
=FILTER(A2:D100, D2:D100>1000)Returns all rows where column D (amount) is greater than 1000.
Filter by region and minimum
=FILTER(A2:D100, B2:B100="West", D2:D100>=500)Returns rows where region is "West" AND amount is at least 500 (multiple conditions = AND logic).
Tips
- ✓Multiple conditions in FILTER use AND logic (all must be true).
- ✓For OR logic, use + between conditions: =FILTER(A:D, (B:B="East")+(B:B="West")).
- ✓Add a third argument as fallback: =FILTER(A:D, B:B="X", "No results") to avoid errors.
Related Formulas
UNIQUE
UNIQUE returns a list of distinct values from a range, removing duplicates. It's...
SUMIFS
SUMIFS adds up values that meet multiple criteria. It's essential for financial ...
QUERY
QUERY is Google Sheets' most powerful function. It lets you use SQL-like syntax ...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free