Filter JSON data or ranges by a given condition.
The range or data that you want to filter by some criteria. For example:
A1:B4 or '
Expression that contains a range/ JSON with the same size as
A1:A5=B1:B5 or A1:A2='"London","Paris"
'. You can combine conditions with "*" (AND) and "+" (OR). Example:(A1:A5>5)*(A1:A5<10)`.
The output of the function when there is no results found.
By default (
FILTER keeps the first row/ column (header). Use
1 to keep it only if it matches conditions.
2 always removes it.