Explanation
TheFILTER functionis designed to extract data that matches one or more criteria.
To do this, we use threebooleanexpressions operating on arrays.
In other words, all three expressions must return TRUE in a given row.
This array is delivered directly to the FILTER function as theincludeargument.
FILTER only includes the 6 rows that correspond to 1s in the final output.
The output from FILTER is dynamic.
If source data or criteria change, FILTER will return a new set of results.
This makes FILTER a flexible way to isolate and inspect data without altering the…
