The FILTER function takes three arguments: array, include, and if_empty. For example, FILTER can match data in a certain year or month, data that contains specific text, or values greater than a certain threshold. Logical tests are supplied as the include argument and can include many kinds of formula criteria. In plain language, the FILTER function will extract matching records from a set of data by applying one or more logical tests. The result is an array of matching values from the original range. The FILTER function "filters" a range of data based on supplied criteria.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |