average finding

0

hello ,

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

Answer
Discuss

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

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.

Discuss

Discussion

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