Hello everybody,
I need to take averages of different groups of data in a large dataset.
What I need to do though is this... I need to average together the values from these rows... rows 1, 58, 115, 172, 229, and so on, basically in increments of 57. Doing this manually would take a long, long time.
After this is complete, I would then need to shift one row up, so that I would then take the average of rows 2, 59, 116, 173, 230, and so on.
After this is done, the same thing happens, and then again, and then again until there is no more to do.
How could I go by doing this?
I have highlighted the pattern in the attached excel file.
Thank you very much,
wrf_89
Bookmarks