Filters a range of data based on criteria you define.
Składnia
FILTER(array, include, [if_empty])Argumenty
arraywymagane
The range or array to filter.
includewymagane
A boolean array where TRUE indicates the row or column should be kept.
if_emptyopcjonalne
The value to return if no items meet the criteria.
The FILTER function allows you to extract data from a range or array based on a boolean condition. It returns a dynamic array that automatically spills into neighboring cells, updating whenever the source data changes.
=FILTER(A2:B5, B2:B5>100)→Filtered rowsReturns all rows from A2:B5 where the value in column B is greater than 100.
Select the target cell
Click the cell where you want the filtered results to begin.
Enter the formula
Type =FILTER( and select your array, followed by the logical condition.
This error occurs if no items meet the criteria and you did not provide an if_empty argument.