What does it do?

Filters a table array based on the filtering condition given

Formula breakdown:

=FILTER(array, include, [if_empty])

What it means:

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

Did you know that you can now filter your table data with an Excel Formula? Yes you can! It is definitely possible now with Excel’s FILTER Formula. It is a new formula introduced in Office 365 released in 2018!

We have a tax table that we want to dynamically filter with a given rate.

Want to know How To Master the FILTER Function in Excel?

*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***

Watch on YouTube and give it a thumbs up 👍


I explain how you can do this below:


STEP 1: We need to enter the FILTER function in a blank cell:


FILTER Formula in Excel


STEP 2: The FILTER arguments:


What is the data to be filtered?

Select the cells containing the tax data, do not include the headers:


FILTER Formula in Excel


What is your filtering condition?

We want to filter the tax rate that is greater than the specified rate. Type in the condition as the tax rate column > the specific tax rate.

=FILTER(C9:D14, D9:D14>G8

FILTER Formula in Excel


What is the value to display in case nothing gets matched?

Just place an empty string to be displayed if nothing gets matched.

=FILTER(C9:D14, D9:D14>G8, “”)

FILTER Formula in Excel


Try it out now with different values and see it get filtered magically!

FILTER Formula in Excel

FILTER Formula in Excel


How to Use the FILTER Formula in Excel





If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn