Excel Functions

Excel FILTER Function

Pinterest LinkedIn Tumblr

The Excel FILTER function filters a range of data based on supplied criteria and extracts matching records. In MS-Excel this function is categorized under lookup&reference function.

Purpose of Excel FILTER Function

To allow you to filter a range of data based on criteria you define.

Return value

This function returns a table array based on the filtering condition given.


= FILTER(array,include,[if_empty])


arrayThe array, or range to filter.Mandatory
includeA Boolean array whose height or width is the same as the array. Mandatory
[if_empty] The value to return if all values in the included array are empty (filter returns nothing).Optional


Available for Office 365.

Related Posts

Write A Comment