Embedded Files
The FILTER function in Google Sheets helps you filter and return the rows in a range that meet specified criteria. You can also add multiple criteria across columns. The FILTER function generates a new set of data while keeping the original data intact.
How to use?
How to use?
SYNTAX: =FILTER(range, condition1, [condition2, …])
range – is the address reference to the range of cells that the function filters.
condition1 – is an array, row or column equal in length or width as that of the corresponding first row or column of range respectively. It contains evaluated TRUE or FALSE values.
condition2 … – these are optional and additional arrays, rows or columns containing evaluated TRUE or FALSE values to specify if the corresponding row or column within the range needs consideration for the filtering process.
PRACTICE SHEET
The below sheet is view only mode, please make a copy to practice.
Page updated
Google Sites
Report abuse