Averaging Large Quantities of Data by Date

[LauraS08]

I have an excel file where columns headers are date and time (by minute), temperature and precipitation. I would like to get the average temperature and average precipitation for each day, across all times. Because of the by the minute recordings, I have approximately 25,000 rows of data. Going through each date and averaging manually seems to be a very time consuming process. Is there a speedier way of accomplishing this? I have no experience with writing Macros but am wondering if that may be a solution. Thank you for your suggestions.

[NickyC]

Hi
have you tried a pivot table?

[LauraS08]

No I haven't. I'm not familiar with how to do that. Any advice would be welcome. Thanks.