i have huge dta of around 30000 rows of data...in excel 2003 format..i mean in excel format..

where i have 6 colums of data..where in each coulum data will get change after every 15 sampels..where i have write code so that i can calculate the average that 15 sampled data....every time i cant keep on doing for evey 15lines ..so i have write a code which does this work at once..i mean compltes for all 30000 lines...plz help me...

Please explain what you are looking for in a little more detail. As examples, do you want:

B15 = AVERAGE(A1:A15)

B30 = AVERAGE(A16:A30)

etc.Or do you want:

B1 = AVERAGE(A1:A15)

B2 = AVERAGE(A16:A30)

etc.Or do you want:

B1 = AVERAGE(A1:A15)

B2 = AVERAGE(A2:A16)

etc.

Hi, If you write a formula for the first 'average' say in column G and row 15, e.g. G15 contains =AVERAGE(A1:A15),

then select cells G1 to G15.

Right-click and copy.

Now select cell G1, then hold down the shift key and select G30000.

All the cells G1 to G30000 are now selected.

Right-click any selected cell and Paste.

This will enter your AVERAGE() formula every 15 lines,

so on row 30 you will have =AVERAGE(A16:A30)

and on row 45 you will have =AVERAGE(A31:A45) and so on.This is a quick way of repeating your formulas at set intervals.

Regards

Ask Your Question

Weekly Poll

How long do you think until flying cars or taxis are common?

Discuss in The Lounge

Poll History