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?
Name | Age | Height | Weight |
Olivia | 25 | 210 | 180 |
Noah | 25 | 205 | 235 |
Oliver | 27 | 195 | 205 |
Elijah | 22 | 198 | 185 |
James | 29 | 199 | 231 |
William | 29 | 201 | 240 |
Benjamin | 21 | 202 | 235 |
Lucas | 25 | 200 | 238 |
Henry | 22 | 204 | 190 |

=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.