Hi there
I was looking for some help
I have a long data range which consists of solar radiation measurements .To this data i am averaging every 5 readings (i.e. taking 5 minute averages of my data). To do this I am using the code attached below.
However the problem I have come up against is that some of the data is missing thus it is putting my averages off slightly by the end.
Besides the column with the measurements I have columns with the hour and minute the value was recorded.
I was wondering if any of you had an idea of how to set the VBA code attached to see if the values are between a range and then average they values.
For example if my solar radiation is in column F and the minute it was recorded is in column E I would like the code to look at the minute value and average all the values in column F when minute is between a range of 5( i.e.between 0 to 4 , then 5 to 9 minutes and so on)all the way up to 59minutes then start again for the nest hour.
Therefore when I am missing a value say the 4th minute I will get the average of 4 cells. But for the 5minutes after I will have the correct average and will not be 1 minute off.
I hope this is clear , does anybody have any idea how to do this , it doesn’t need to use the code ive been using already , if its no use i have attached the workbook i am using if this helps anybody .
Thank you in advance
Bookmarks