We can extract Values greater or smaller than a certain number.
For example, in the table above, we want to know Who is taller than 201?

=FILTER(A8:D16,(C8:C16>201 ))
answer is {Benjamin,21,202,235}
FILTER function
The FILTER function is one of the Lookup & reference functions of Excel.
It extracts all record from the database that matches the specified conditions.
FILTER Arguments
FILTER(array, include, [if_empty])
FILTER function has 3 arguments:
- array you can enter the range of cells that make up the list or database.
- include is either the label of the column in double quotation marks.
- [if_empty] is the range of cells that contains the conditions you specify.