FILTER whole rows
Return every column of the matching rows, not just one.
Task:
The South team wants its own view of the pipeline. In E2, return the deal, region and value columns for every South deal.
Interactive Spreadsheet
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of FILTER
0/3The same formula in the other shapes it takes at work.
- Show only the invoices that are actually overdue
FILTER keeps the rows where your condition holds.
CoreIntermediate - FILTER whole rows
Return every column of the matching rows, not just one.
Intermediate - FILTER driven by a cell
Point the condition at an input cell and the view changes when it does.
Intermediate
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Deal | Region | Value | Deal | Region | Value | |
| 2 | D-101 | North | 12000 | ||||
| 3 | D-102 | South | 8500 | ||||
| 4 | D-103 | East | 22000 | ||||
| 5 | D-104 | South | 4300 | ||||
| 6 | D-105 | North | 9100 | ||||
| 7 | D-106 | South | 15750 |
What this exercise teachesMay contain the answer
The array and the condition only need the same number of rows; the array can be as wide as you like. The result is a live view — add a South deal to the source and the view grows by a row.