0
0
Google Sheetsspreadsheet~10 mins

WHERE clause for filtering in Google Sheets - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

This table lists people with their names, ages, and cities.

CellValue
A1Name
B1Age
C1City
A2Alice
B230
C2New York
A3Bob
B325
C3Los Angeles
A4Charlie
B435
C4Chicago
A5Diana
B528
C5New York
Formula Trace
=FILTER(A2:C5, B2:B5>28)
Step 1: B2:B5>28
Step 2: FILTER(A2:C5, [TRUE, FALSE, TRUE, FALSE])
Cell Reference Map
    A       B       C
1 |Name   | Age   | City    |
2 |Alice  | 30    | New York|
3 |Bob    | 25    | Los Angeles|
4 |Charlie| 35    | Chicago |
5 |Diana  | 28    | New York|
The formula uses the Age column (B2:B5) to filter rows from the full table A2:C5.
Result
    A       B       C
1 |Name   | Age   | City    |
2 |Alice  | 30    | New York|
3 |Charlie| 35    | Chicago |
The FILTER formula returns only rows where Age is greater than 28, showing Alice and Charlie's data.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the expression B2:B5>28 return?
A[TRUE, FALSE, TRUE, FALSE]
B[FALSE, TRUE, FALSE, TRUE]
C[TRUE, TRUE, TRUE, TRUE]
D[FALSE, FALSE, FALSE, FALSE]
Key Result
FILTER(range, condition) returns rows from range where condition is TRUE.