> For the complete documentation index, see [llms.txt](https://enable-advisory-1.gitbook.io/the-way-we-work/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://enable-advisory-1.gitbook.io/the-way-we-work/microsoft-excel/filter.md).

# FILTER

**Syntax:**

\=FILTER(array, include, \[if\_empty])

**Explanation:**

* *array* - Range or array to filter.
* *include* - Boolean array, supplied as criteria.
* *if\_empty* - \[optional] Value to return when no results are returned.

**Example:**

<figure><img src="https://1421118769-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MdtjvomCsvuXz1wFFAA%2Fuploads%2FnpfFUusPMqk1esYM95ha%2Fimage.png?alt=media&amp;token=bbb95bd1-f624-42bf-88a4-6b721d378e7e" alt=""><figcaption></figcaption></figure>

**Notes:**

The FILTER function "filters" a range of data based on supplied criteria. The result is an array of matching values from the original range.

In plain language, the FILTER function will extract matching records from a set of data by applying one or more logical tests. Logical tests are supplied as the include argument and can include many kinds of formula criteria. For example, FILTER can match data in a certain year or month, data that contains specific text, or values greater than a certain threshold.