![]() ![]() 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |