Earlier, I asked how I could skip columns, and was answered in the
following manner:

On cell A700 type
aand copy it across B700 and so on .

Now I am asking if I can use the above with an array formula. My data
is 'raw data'!e3:e650 and 'raw data'!f3:f650. I would like to simply
divide the two columns and get an average, and can do so using an array

My question is how can I do this calculation on a different sheet, using
OFFSET as above. I have tried,


but the value given is incorrect.

Any help is appreciated.


P.S. - I had to modify the above OFFSET formula to read
"...COLUMN()*7-14...", instead of "...COLUMN()&7-7..."