Question I have time series data collected every second for 1 day. I need 10 second averages.
The time (11:43:00, 11:43:01, 11:43:02...) are in column A and the data I need averaged are in column B (20, 34, 25...)
I am trying to write a macro which will help me with data analysis.I have my data stored in Excel. I have about 86400 data points (for each day and I need to do this for about 30 days.) I know how to get the averages by typing in =average(b2:b12).. but I do not want to have to do this 8000 times in each sheet. I do not want running averages, just the average of column B every 10 seconds. Is there another way to do this in Excel with a macro?
Answer Hi molly,
As you said you have 86400 data points. One quick question, are these data points stored in two separate worksheets(like in sheet1 have 40000 and sheet2 have 46400) ?
In Excel worksheet it is not possible to store more than 65536 rows.
Do you want these averages in the same worksheet or in different worksheet?
Reply me as soon as possible I will give you the code.
