FILTER()

Description

Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions.

How To Use in Sheets

FILTER(range, condition1, [condition2])

External Links

Google Sheets Filter Function - 8 actionable examples

Learn how to use the powerful Google Sheets Filter function in your data analysis to filter your data quickly.

15Better Sheets Tutorials