How Ranges Change
Key points
- Enter the formula
- See the formula
- Check it
In ARRAYFORMULA Builder, B2 becomes a whole-column range like B2:B.
Steps
- Enter the formula
- See the formula
- Check it
Each cell reference becomes its own whole column.
Use "Build an ARRAYFORMULA" (free)
Tools that go well with this
- Build a QUERY Formula: Build a QUERY formula.
- Build a FILTER Formula: Build a FILTER formula.
- Build an IF Formula: Build an IF formula.