Syntax
Filter(Table, Condition1 [, Condition2, ...])Parameters
Table- The table or data source to filter.
Condition- A test for each record. All conditions must be true.
Examples
=Filter([5, 12, 30, 8], Value > 10)12, 30
Filter
Returns the records of a table that meet every condition you give.