More Excel Help

[D-rail]

I have an extremely large column of imported data. Does anyone know how I can average every 15 cells of data or at least segment the data into groups of 15 and then average those groups? I would like to be able to start a new column and have the average's run successively..ie:

cells A1:A15 average
cells A16:A30 average
cells A31:A45 average
etc.

The data contains random numbers in decimal form..ex: 1, 1.033, 1.067, 30.556, etc.

I have about 200 iterations of the average that needs to be run and I do not want to have to go in and manually edit the "average" function for each series of 15. Copying and pasting the "average" function only adds 1 to the previous cells number...any way to make this increment in multiples of 15?

Any help is appreciated.