Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions.
Description
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
14