Excel FILTER Function
The FILTER function "filters" a set of data based on the criteria you provide. The result is an array of values from the original range that match. In layman's terms, the FILTER function will extract matching records from a set of data using one or more logical tests. Logical tests are provided as the include argument and can contain a variety of formula criteria. FILTER, for example, can match data from a specific year or month, data containing specific text, or values greater than a certain threshold.
FILTER accepts three arguments: array, include, and if empty. The range or array to filter is denoted by array. One or more logical tests should be included in the include argument. Based on the evaluation of array values, these tests should return TRUE or FALSE. The final argument, if empty, specifies the outcome to be returned when FILTER finds no matching values. Typically, this is a message such as "No records found," but other values can also be returned. To display nothing, enter an empty string ("").
FILTER produces dynamic results. When the values in the source data change, or the source data array is resized, the FILTER results will automatically update. FILTER results will "spill" into multiple cells on the worksheet.
Syntax
=FILTER (array, include, [if_empty])
Arguments
array- Range or array to filter.
include - Boolean array, supplied as criteria.
if_empty -[optional] Value to return when no results are returned.
Please Watching My Video is below
No comments:
Post a Comment