Hi there, I'm currently trying to produce some results from a study I'm doing for my dissertation and I was wondering if anyone could help me with this problem:
I have about 100 columns that I have been punching the following formula pattern into:
=AVERAGE(O12:O19)
=AVERAGE(O20:O27)
=AVERAGE(O28:O35)
etc.
This is simply to produce for one column the average for 8 blocks in the O column, with the following new column showing the average for the next 8 blocks, and so on and so on.
I've tried to fill in the many columns using the small black cross in the bottom right corner, however, excel produces the following:
=AVERAGE(O12:O19)
=AVERAGE(P12:O19)
=AVERAGE(Q12:Q19)
etc.
I've tried my hardest to find a quicker way to do this, but have so far been doing it manually (which is taking forever!) since my excel skills aren't exactly great. If anyone could help me find a solution I'd be forever grateful!
Best,
Ren.
Bookmarks