So following on from a post over the weekend when I got some fantastic help with some data I am using for my dissertation, I was wondering if anyone had any ideas how to solve this one...
I've got a list of days and times during a year, and with each of these I have values for the wind direction. I need a list of daily mean wind directions to go alongside the column (in sheet 2) of days of the year.
This is obviously complicated by the fact that excel wont understand that the average of say, 10 and 350 is 0 (not 180).
Does anyone have any idea how I could get what I'm after?
(I've attached the file to show the data that I'm working with)
Thanks in advance for any help
Andy
Bookmarks