FILTER
Description
Returns a filtered range of data based on criteria that you specify.
Syntax
FILTER(
array
, include
, [ if_empty
]) - array: The value or expression to evaluate.
- include: A Boolean array with the same height or width asarray, that identifies the data to return.
- if_empty: The value to return if the expression results in an empty array. The result must be both empty and an array; otherwise, the function returns the #VALUE error.
Example
This is the original spreadsheet:
A | B | C | |
|---|---|---|---|
1 | Name | Grade | 90 |
2 | Joe | 85 | |
3 | Alice | 92 | |
4 | Annri | 88 | |
5 | Navin | 97 | |
6 | Carlos | 89 | |
7 | Ren | 91 |
The result of
=FILTER(A1:B7,B1:B7>C1)
, where the formula is placed in cell F1, submitted using the unconstrained array keyboard shortcut, is: F | G | |
|---|---|---|
1 | Name | Grade |
2 | Alice | 92 |
3 | Navin | 97 |
4 | Ren | 91 |