hello ,

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

0

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: 1282) 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

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.