How to Use FILTER in Google Sheets
The FILTER function extracts rows from a range that meet one or more conditions. It is more powerful than AutoFilter for complex filtering needs.
Understand FILTER Syntax
FILTER(range, condition1, [condition2, ...]). The range is the data to filter, and conditions determine which rows to include.
Apply a Single Condition
Use =FILTER(A1:C100, B1:B100="Active") to show only rows where column B equals "Active".
Use Multiple Conditions
Use =FILTER(A1:C100, B1:B100="Active", C1:C100>100) to find active records with values over 100. All conditions must be TRUE.
Use OR Logic with +
Use =FILTER(A1:C100, (B1:B100="Active") + (B1:B100="Pending")) to filter rows where status is either Active or Pending.
💡 The + operator acts as OR when wrapping conditions in parentheses.
Try These Templates
Frequently Asked Questions
What is the difference between FILTER and AutoFilter?
FILTER is a formula that creates a dynamic result range. AutoFilter temporarily hides rows. FILTER results update automatically when source data changes.
Can FILTER return data to another sheet?
Yes. Use FILTER in any sheet to extract data from another sheet by referencing the source sheet range.