0
0
Google Sheetsspreadsheet~10 mins

FILTER function in Google Sheets - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

This table shows names and ages of four people.

CellValue
A1Name
B1Age
A2Alice
B230
A3Bob
B325
A4Charlie
B435
A5Diana
B528
Formula Trace
=FILTER(A2:A5, B2:B5>28)
Step 1: B2:B5>28
Step 2: FILTER(A2:A5, [TRUE, FALSE, TRUE, FALSE])
Cell Reference Map
    A       B
1 |Name   | Age  |
2 |Alice  | 30   |
3 |Bob    | 25   |
4 |Charlie| 35   |
5 |Diana  | 28   |

Formula references A2:A5 and B2:B5 for filtering.
The formula uses the names in A2:A5 and checks ages in B2:B5 to filter names with age > 28.
Result
    C
1 |Filtered Names|
2 |Alice         |
3 |Charlie       |
The FILTER formula outputs the names Alice and Charlie in the result column because their ages are greater than 28.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the condition B2:B5>28 return for the ages?
A[TRUE, TRUE, TRUE, TRUE]
B[FALSE, TRUE, FALSE, TRUE]
C[TRUE, FALSE, TRUE, FALSE]
D[FALSE, FALSE, FALSE, FALSE]
Key Result
FILTER(range_to_return, condition_range condition) returns values from range_to_return where condition is TRUE.