1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

trying to average groups from a column

Hello,

I have a long column of data and I have to get the average of x rows, and then the next x, and then the next etc. So for example average(A2:A6) and then average(A7:A11), average(A12:A16),...,average(A_n:A_n+4). Is there a way to do this with one command and maybe create a new column with these averaged values? i hope this makes sense D: thank you so much! im really new to excel

submitted by /u/Forsaken_Title_9387
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com