Hello,
I am having trouble getting Excel to pick up on a pattern. I have two spreadsheets. Sheet 1 contains data and Sheet 2 is form statistical computations on sheet 1 data. I think the reason is beause my computations use the same cell twice. How can I overcome this? Here is simple pattern of what I would like to do. Each time the range increases by 6 but still uses the last cell from the previous computation. I would like to be able to drag this pattern across the entire spreadsheet since there are nearly 5000 cells but Excel will not pick up the pattern.
=AVERAGE(Data!A1:A6)
=AVERAGE(Data!A6:A12)
=AVERAGE(Data!A12:A18)
I am having trouble getting Excel to pick up on a pattern. I have two spreadsheets. Sheet 1 contains data and Sheet 2 is form statistical computations on sheet 1 data. I think the reason is beause my computations use the same cell twice. How can I overcome this? Here is simple pattern of what I would like to do. Each time the range increases by 6 but still uses the last cell from the previous computation. I would like to be able to drag this pattern across the entire spreadsheet since there are nearly 5000 cells but Excel will not pick up the pattern.
=AVERAGE(Data!A1:A6)
=AVERAGE(Data!A6:A12)
=AVERAGE(Data!A12:A18)