Need your help because I am not sure of the correct formula to use (if ever there is one!) in Excel 2010.
Say in column A, I have my figures (A1 to A1000). Suppose in column B I need to get the average of A1 to A10. So for B1 my formula is
=average(A1:A10). Then for B2, next to get the average of the next 10 figures in column A, i.e., A11 to A20. Is there an easier way to do this? Because if I just copy/drag the formula, B2 becomes
=average(A2:A11) when what I need is for it to be