average finding


hello ,

i have banch to number and find the averge of interval of 5 in other place.pls suggest the excel macros.



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: 1492) 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
Add to Discussion



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:


If you want one that you can copy to the right as well as down, try this one:


Both formulas assume they will first be put into row 1.



avg.xlsx see i send one attachment of my example and any excel macros code for this example  
ravi1097 (rep: 4) Aug 5, '16 at 6:59 pm
My formulas do that... did you even try them?
don (rep: 1492) Aug 8, '16 at 4:26 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login