Excel Filter Function – Syntax
Below is the syntax of the FILTER function:
= FILTER(array,include,[if_empty])- array – this is the range of cells where you have the data and you want to filter some data from it
- include – this is the condition that tells the function what records to filter
- [if_empty] – this is an optional argument where you can specify what to return in case no results are found by the FILTER function. By default (when not specified), it returns the #CALC! error
‣
Example 1: Filtering Data Based on One Criteria (Region)
‣
Example 2: Filtering Data Based on One Criteria (More Than or Less Than)
‣
Example 3: Filtering Data with Multiple Criteria (AND)
‣
Example 4: Filtering Data with Multiple Criteria (OR)
‣
Example 5: Filtering Data To Get Above/Below Average Records
‣
Example 6: Filtering Only the EVEN Number Records (Or ODD Number Records)
‣