Dear Forum Members,
I have tried to work this out on my own with no success - I don't really know how to begin the logic!
In the code above, YearStd is a Varient variable that calculates the standard deviation of the entire column. Instead, I need the calulation based upon the hour and the year. In column A I have time in the format 9/1/2011 1:00. (You can also see that I have struggled with the looping - right now, I have to know the last column and have commented out the "Do WHile" loop)
I need to group the data by year then hour; e.g., all 2011 and 1:00 together, and then calculate standard deviation, among other things, for all values in year 2011 and hour 1:00 and possibly all values for all years in hour 1:00; etc.
I have attached a sample spreadsheet to this post.
Thank you for reading this request for help.
Chris
Bookmarks