Hi there,
I have an excel document which has rows and rows of data, however, I want to average the data every 12 rows (the data is taken every 5 seconds and I want to convert it to 60 second averages). Is there any way to write a macro to generate a new column by averaging the 12 data points and then putting it into one uninterrupted column?
Thanks very much, James
I have an excel document which has rows and rows of data, however, I want to average the data every 12 rows (the data is taken every 5 seconds and I want to convert it to 60 second averages). Is there any way to write a macro to generate a new column by averaging the 12 data points and then putting it into one uninterrupted column?
Thanks very much, James