The criteria that set in the condition can be manually typed into the formula as a number or text, or it can also be a cell reference.
The range that is used to check against the criteria that you set, must be a single column (later I will show you how to filter by multiple conditions, but don’t worry about that for now). The source range that you want to filter, can be a single column or multiple columns. Google Sheets description for FILTER function:įILTER(range, condition1, )įormula summary: “Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions.” The FILTER function in Google Sheets allows you to filter a range of data by a specified condition, so that a new set of data will be displayed which only shows the rows/columns from the original data set that meets the criteria/condition set in the formula. (Copy/Paste the formula above into your sheet and modify as needed) Click here to read the Excel version of this article Using the FILTER function in Google Sheets is almost the same as using it in Excel, but there are slight differences between the two.
Type the address for the range of cells that contains the data that you want to filter, such as A1:B.Type =FILTER( to begin your filter formula.To filter by using the FILTER function in Google Sheets, follow these steps: The FILTER function is a very useful and frequently used function, that you will likely find the need for in many situations.