•1 min read•from 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
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#generative AI for data analysis
#Excel compatibility
#financial modeling with spreadsheets
#Excel alternatives
#natural language processing for spreadsheets
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#average
#column
#Excel
#data