I have a large data set (~70,000 rows) that contains temperatures at various dates/times. Column A contains the date/time and B contains temperatures (see below). What I would like to do is create a new data set with just the daily min, max and average temperatures (one line of data for each date). I have a dozen or so such data sets, so I wanted a generic macro that I can apply to any of them and continue to use as additional data is added.
Thanks for any help!
<tbody>
</tbody>
Thanks for any help!
Date/Time | °F |
12/31/10 0:26 | 86.9 |
12/31/10 0:56 | 86.9 |
12/31/10 1:26 | 86.9 |
12/31/10 1:56 | 87.1 |
12/31/10 2:26 | 86.9 |
12/31/10 2:56 | 86.9 |
12/31/10 3:26 | 86.9 |
12/31/10 3:56 | 86.9 |
12/31/10 4:26 | 86.7 |
<tbody>
</tbody>