I have Excel data similar to the structure below
columnA Column B Column C Column D
month day time temperature
1 1 100 32
1 1 130 33
1 2 100 29
1 2 130 35
1 2 200 33
1 2 230 36
I would like to calculate the daily average temperatures. It would b
easy if every month have the exact same number of days, but it doesn't
and I have many years and many months to calculate, so I think macro i
the easiest and fastest way to do this.
Could someone write a basic macro that will calculate the daily averag
temperature? I assume one 'if statement' would be to check if the da
(column B) is the same.
thanks for any input
--
jaguar
-----------------------------------------------------------------------
jaguarr's Profile:
http://www.excelforum.com/member.php...fo&userid=2615
View this thread:
http://www.excelforum.com/showthread.php?threadid=39478