'Iterate a range within a formula in sheets
I haven't been able to find if there's a 'quick' way to iterate the range of a column. In many formulas you have to have to first select the range of the sheet like
'Data'!A1:C1
I want to know if there's an easy way to iterate the column for the following rows when you drag the formula to the rows below so the formula in the next row is
'Data'!B2:C2
Is it possible? Thanks in advance.
Solution 1:[1]
possible:
="Data!"&ADDRESS(ROW(A2), ROW(A2), 4)&":"&ADDRESS(ROW(A2), 3, 4)
do not forget to convert it into actual range by wrapping it into INDIRECT
Solution 2:[2]
Try
'Data'!A"&row()&":C"&row()
you could change row()/+- with a corresponded number for the fit you want.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | player0 |
| Solution 2 | Dharmik Patel |