Follow JLatham's advice.
--
Gary's Student
gsnu200705


"Rob" wrote:

On 10 Feb, 15:17, Gary''s Student
wrote:
How about averaging the data in groups. Let's say we have 10 seconds of data
at 60 HZ in column A in cells A1 thru A600.

In B1 enter:
=AVERAGE(INDIRECT("A"&((ROW()-1)*60+1)&":A"&((ROW()-1)*60+1)+59))
and copy down thru B10

This gets us the average of 1 thru 60,
then the average of 61 thru 120,
etc.

--
Gary's Student
gsnu200705

"Rob" wrote:
I have large files that are to be analysed, which are taken from a
recorder at 60 Hz. Sixty readings per second is far more than
necessary for my purposes, and I wondered whether there is a quick way
to 'refine' this data, like make a new file from the existing one that
has 5 or six readings per second.... What's the quickest way to do
this?

Any help would be appreciated!

Rob

Thanks for that, but I'm more looking to simply discard 9 out of 10
entries, and there are many columns in each file... Is there an any
way of doing this, or an application to do it?

Thanks

Rob