How to extract Values ​​greater or smaller than a certain number

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.

Related posts:

How to Anchor Cells in Excel How to Use Chat GPT with Excel Excel DCOUNT Function Excel DCOUNTA function