how to write code for this

January 29, 2010 at 03:00:03
Specs: Windows XP
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...

See More: how to write code for this

Report •

#1
January 29, 2010 at 03:55:52
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.


Report •

#2
January 29, 2010 at 05:30:34
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


Report •
Related Solutions


Ask Question