The **FILTER** function in <span style="color:darkgreen; font-weight: bold;">Excel</span> is designed to filter a range of data based on specified criteria and return the matching values. This function is highly useful for data analysis, reporting, and data management tasks.

<div style="display: flex; justify-content: center;"><i>=</i><b>FILTER</b>(<span style="color: indigo">array</span>,&nbsp;<span style="color: green">include</span>,&nbsp;<span style="color: brown">[if_empty]</span>)</div>

|  |                                                                                       |
|-----------|---------------------------------------------------------------------------------------------------|
| <span style="color: indigo">array</span>     | The range or array to filter.                                                                     |
| <span style="color: green">include</span>   | A Boolean array, where **TRUE** represents the values to include.                                      |
| <span style="color: brown">[if_empty]</span>  | <i>(Optional)</i> The value to return if no entries meet the criteria. If omitted, it returns a `#CALC!` error. |

So, again, nothing too complicated. First, we provide a range we want to filter. The next parameter, as specified above, is a Boolean array, but where can we find it? Actually, a Boolean array is simply a range of True or False values. We can take any range and turn it into a Boolean array with an array formula.

What we did here is just applied a condition to the range of values. We can acheave it using `>`, `<`, `=` and so on.

Suppose you have a list of sales data with product names in column A and sales figures in column B. You want to filter out only the products with sales greater than 250.

First, select column A where the product names are listed. Next, create a boolean array to identify which products meet the sales criteria. You can create this array separately and then use it, or you can integrate it directly into the formula.

> Note
>
> If no products have a count greater than the specified threshold, you will get a `#CALC!` error. To prevent this, you can specify a third parameter in the formula that will be displayed if there is no match.

What happens if no entries meet the criteria specified in the FILTER function and the if_empty argument is omitted?

This course is designed for beginners who want to start exploring formulas in Excel. You'll begin with the basics and then discover some really useful formulas for daily use. You'll learn about array formulas and how they work, and you'll also dive into Lookup and Reference functions.

In this section you will learn how to input and use Excel formulas for various calculations, including basic operations like addition, subtraction, multiplication, division, and power. Discover the importance of using functions for clearer and more efficient calculations. Explore statistical functions like AVERAGE, MEDIAN, MODE, MIN, and MAX to analyze data effectively.

In this section you will learn about array formulas in Excel and how they enable multiple calculations on sets of values simultaneously and how to use specific functions like UNIQUE, SORT, FILTER, and TRANSPOSE.

In this section, you will learn about lookup and reference formulas in Excel. These formulas enable you to search for and retrieve specific data from a table or range. You will explore essential functions such as VLOOKUP, HLOOKUP, MATCH, INDEX, and XLOOKUP, which are invaluable for finding and referencing data efficiently.


array	The range or array to filter.
include	A Boolean array, where TRUE represents the values to include.
[if_empty]	(Optional) The value to return if no entries meet the criteria. If omitted, it returns a `#CALC!` error.

Excel Formulas

FILTER