What does it do?
Filters a table array based on the filtering condition given
=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 ***
I explain how you can do this below:
STEP 1: We need to enter the FILTER function in a blank cell:
STEP 2: The FILTER arguments:
What is the data to be filtered?
Select the cells containing the tax data, do not include the headers:
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.
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, “”)
Try it out now with different values and see it get filtered magically!
How to Use the FILTER Formula in Excel