hello ,
i have banch to number and find the averge of interval of 5 in other place.pls suggest the excel macros.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
average finding
0
Discussion
I'm not sure what you mean, can you include a sample before and after in the workbook? Looking at the workbook and reading your description, I'm just not sure exactly what you are trying to do.
don (rep: 1989) Aug 5, '16 at 11:59 am
i want the average of 1st 1 to 5 row in all colume ,after that average 5 to 9 colume for next and goind on and all the data mention in other colume in row wise.
ravi1097 (rep: 4) Aug 5, '16 at 1:28 pm
Answers
0
I'm still not sure what you want exactly, but if you want to average every 5 rows and have a formula that you can copy down to do that, you can use this formula:
=AVERAGE(INDIRECT("A"&ROW()*5-4&":"&"A"&ROW()*5))If you want one that you can copy to the right as well as down, try this one:
=AVERAGE(INDIRECT(CHAR(64+COLUMN(A1))&ROW()*5-4&":"&CHAR(64+COLUMN(A1))&ROW()*5))Both formulas assume they will first be put into row 1.