Hi all,


I have a large amount of test data that I need to process into useable information. Because of my hardware, the test sample rate was over 1000Hertz. Anyway,I need to reduce the length of the columns of test data by averaging them every 17 rows. I attached a sample of the data I am working with, some of the data is over 100,000 rows. I cannot figure out how to begin averaging the data and increment the range until the end of the column. Please help....
BTW, I am using excel2010, if that matters.



test book1.xlsx