Abstract
Transcript
In this video, well set up theFILTER functionwith a basic example.
Filtering to extract data based on matching criteria is a traditionally hard problem in Excel.
However, the new FILTER function makes this task much easier.
The FILTER function is designed to extract data from a list or table using supplied criteria.
In this worksheet, we have data that contains names, scores, and groups.
Our goal is to use the FILTER function to filter the data by group.
Once we have a match, Ill press the TAB key.
The first argument is calledarray.
This is the data we want to filter.
In this case, thats the range B5:D14.
Next, we need to provide an argument called"include".
Theincludeargument is actually what does the filtering.
In this case, that means it must have the same number of rows.
Let’s filter on the Blue group.
To do this, I enter the expression D5:D14=“blue”.
Note that FILTER is not case-sensitive.
The next argument is the optional"is_empty"argument.
This message only appears when FILTER can find no matching data.
I’ll use “no results” in double quotes.
When I hit enter, FILTER extracts just the data in the blue group.
I need to adjust theincludeargument to use this value instead.
Now I when I change H2 to “red” we get a new set of results.
Finally, notice these results are dynamic.
If I temporarily change a group in the source data, results update instantly.
