I have a formula:
"OFFSET(INDIRECT($B$3),2,0)" array entered
B3 contains a range e.g. "c8:h8" without quotes
I want to copy the above formula down. The value in B3 is a singular global value, so I don't want to create a column for it. So I tried:
"OFFSET(INDIRECT($B$3),2+row(),0)" array entered, but it only returns the first value in the array.
Any idea how to fix this, or alternatives so I can copy the formula down?
"OFFSET(INDIRECT($B$3),2,0)" array entered
B3 contains a range e.g. "c8:h8" without quotes
I want to copy the above formula down. The value in B3 is a singular global value, so I don't want to create a column for it. So I tried:
"OFFSET(INDIRECT($B$3),2+row(),0)" array entered, but it only returns the first value in the array.
Any idea how to fix this, or alternatives so I can copy the formula down?