How to extract certain rows in Excel?

By using FILTER function, we can extract a specific record from table in excel.

For example, in the table below, we want to know how old is benjamin?

=FILTER(A7:D16,(A7:A16="benjamin" ))
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 Use Chat GPT with Excel How to Anchor Cells in Excel Excel DCOUNTA function Excel LOWER Function