Hi all,
I have Sheet 1, with data starting at Row 17, with a value in every 132rd row (i.e. next cell at Row 149, then 281 etc.) and I need to copy this value into another sheet in consecutive rows by dragging the formula down the rows.
Extra information:
For Sheet 2, the formula starts at Row 16
I'm trying to figure out how to formulate the offset formula to do so, but I'm not too sure what to insert for the ROW referencing:
=OFFSET('Sheet 1'!Q17,ROW()*132,0)
Appreciate any help here.
I have Sheet 1, with data starting at Row 17, with a value in every 132rd row (i.e. next cell at Row 149, then 281 etc.) and I need to copy this value into another sheet in consecutive rows by dragging the formula down the rows.
Extra information:
For Sheet 2, the formula starts at Row 16
I'm trying to figure out how to formulate the offset formula to do so, but I'm not too sure what to insert for the ROW referencing:
=OFFSET('Sheet 1'!Q17,ROW()*132,0)
Appreciate any help here.