## FILTER Formula

**Previously in ****Excel Formulas****:** **How to use SORTBY Formula in Excel?**

Use of this formula: It helps to filter a table array based on the filtering of the given condition

**Address Formula breakdown:**

`=FILTER`

(array, include, [if_empty])

**Explanation:**

`=FILTER`

(data to be filtered, the filtering condition, [value to display if nothing gets matched])

If you don’t know that you can now filter your table data with an Excel Formula then don’t worry it is possible with the** FILTER Formula**. It is a new formula which was introduced in Office 365 that has been released in 2018.

**Click here to enroll in the Microsoft Office Insider Program**

**STEP 1:** firstly you have to enter the FILTER function in a blank cell of your table e.g.

**=FILTER(**

**STEP 2:** now continue with the **FILTER **arguments.

*array*

write the data you need to be filtered at the place of array.

So select the cells containing the tax data, do not include the headers like this:

**=FILTER(A2:B6**

*include*

Now write your filtering condition.

I want to filter the tax SLABS that is greater than the specified rate so here I have to type in the condition as the tax SLABS column > the specific tax SLABS.

**=FILTER(A2:B6,B2:B6>E1**

*[if_empty]*

Here write the value that needs to display in case nothing gets matched so for this just place an empty string to be displayed.

**=FILTER( A2:B6,B2:B6>E1, “”)**

Now do it with different values and see it get filtered.

**NOTE**: Number given below is in decimals that means % has been converted to whole numbers.