Hi,
I have an excel sheet which has three columns Date, Time and Temperature. The data is hourly recorded with the start date of 4/11/2011 and time: 12:00:00 AM and the end date of 4/13/2021 and time: 12:00:00 AM i.e. 10 years of data. I need to condense this data by day and maximum value in a month. So for example for a year let say 2011 I should only have 9 records with Date and Maximum Temperature Value.
Please see the sample data (for 5 days) below.
Advice and suggestions will be appreciated.
I have an excel sheet which has three columns Date, Time and Temperature. The data is hourly recorded with the start date of 4/11/2011 and time: 12:00:00 AM and the end date of 4/13/2021 and time: 12:00:00 AM i.e. 10 years of data. I need to condense this data by day and maximum value in a month. So for example for a year let say 2011 I should only have 9 records with Date and Maximum Temperature Value.
Please see the sample data (for 5 days) below.
Advice and suggestions will be appreciated.
Test Temp Data.xlsx | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Day | Time | Temperature | ||
2 | 4/11/2011 | 12:00:00 AM | 89.62777937 | ||
3 | 4/11/2011 | 1:00:00 AM | 89.83070039 | ||
4 | 4/11/2011 | 2:00:00 AM | 89.99633733 | ||
5 | 4/11/2011 | 3:00:00 AM | 89.79770601 | ||
6 | 4/11/2011 | 4:00:00 AM | 89.77417411 | ||
7 | 4/11/2011 | 5:00:00 AM | 89.74658754 | ||
8 | 4/12/2011 | 2:00:00 AM | 89.703755 | ||
9 | 4/12/2011 | 3:00:00 AM | 89.71455472 | ||
10 | 4/12/2011 | 4:00:00 AM | 89.72420336 | ||
11 | 4/12/2011 | 5:00:00 AM | 89.72695207 | ||
12 | 4/12/2011 | 6:00:00 AM | 89.74372769 | ||
13 | 4/12/2011 | 7:00:00 AM | 89.77702503 | ||
14 | 4/12/2011 | 8:00:00 AM | 89.80854813 | ||
15 | 4/12/2011 | 9:00:00 AM | 89.81030336 | ||
16 | 4/12/2011 | 10:00:00 AM | 89.81454374 | ||
17 | 4/12/2011 | 11:00:00 AM | 89.81543155 | ||
18 | 4/12/2011 | 12:00:00 PM | 89.81564971 | ||
19 | 4/12/2011 | 1:00:00 PM | 89.84937027 | ||
20 | 4/12/2011 | 2:00:00 PM | 89.86433073 | ||
21 | 4/12/2011 | 3:00:00 PM | 89.90774513 | ||
22 | 4/12/2011 | 4:00:00 PM | 89.91678239 | ||
23 | 4/12/2011 | 5:00:00 PM | 89.8968723 | ||
24 | 4/12/2011 | 6:00:00 PM | 89.88171432 | ||
25 | 4/12/2011 | 7:00:00 PM | 89.90538762 | ||
26 | 4/12/2011 | 8:00:00 PM | 89.90920861 | ||
27 | 4/12/2011 | 9:00:00 PM | 89.89170028 | ||
28 | 4/12/2011 | 10:00:00 PM | 89.90048188 | ||
29 | 4/12/2011 | 11:00:00 PM | 89.91579807 | ||
30 | 4/13/2011 | 12:00:00 AM | 89.94183986 | ||
31 | 4/13/2011 | 1:00:00 AM | 89.94780055 | ||
32 | 4/13/2011 | 2:00:00 AM | 89.89907908 | ||
33 | 4/13/2011 | 3:00:00 AM | 89.91624186 | ||
34 | 4/13/2011 | 4:00:00 AM | 89.90061185 | ||
35 | 4/13/2011 | 5:00:00 AM | 89.90005451 | ||
36 | 4/13/2011 | 6:00:00 AM | 89.92957078 | ||
37 | 4/13/2011 | 7:00:00 AM | 89.92594145 | ||
38 | 4/13/2011 | 8:00:00 AM | 89.94034973 | ||
39 | 4/13/2011 | 9:00:00 AM | 89.93831181 | ||
40 | 4/13/2011 | 10:00:00 AM | 89.97381138 | ||
41 | 4/13/2011 | 11:00:00 AM | 89.91008465 | ||
42 | 4/13/2011 | 12:00:00 PM | 89.9221225 | ||
43 | 4/13/2011 | 1:00:00 PM | 89.94248089 | ||
44 | 4/13/2011 | 2:00:00 PM | 89.92203148 | ||
45 | 4/13/2011 | 3:00:00 PM | 89.91160678 | ||
46 | 4/13/2011 | 4:00:00 PM | 89.89667063 | ||
47 | 4/13/2011 | 5:00:00 PM | 89.89071318 | ||
48 | 4/13/2011 | 6:00:00 PM | 89.88855241 | ||
49 | 4/13/2011 | 7:00:00 PM | 89.92544305 | ||
50 | 4/13/2011 | 8:00:00 PM | 89.90270771 | ||
51 | 4/13/2011 | 9:00:00 PM | 89.8626188 | ||
52 | 4/13/2011 | 10:00:00 PM | 89.85639712 | ||
53 | 4/13/2011 | 11:00:00 PM | 89.85573732 | ||
54 | 4/14/2011 | 12:00:00 AM | 89.82276248 | ||
55 | 4/14/2011 | 1:00:00 AM | 89.81841965 | ||
56 | 4/14/2011 | 2:00:00 AM | 89.82992964 | ||
57 | 4/14/2011 | 3:00:00 AM | 89.79677694 | ||
58 | 4/14/2011 | 4:00:00 AM | 89.80410821 | ||
59 | 4/14/2011 | 5:00:00 AM | 89.77753227 | ||
60 | 4/14/2011 | 6:00:00 AM | 89.79805526 | ||
61 | 4/14/2011 | 7:00:00 AM | 89.76632318 | ||
62 | 4/14/2011 | 8:00:00 AM | 89.79313255 | ||
63 | 4/14/2011 | 9:00:00 AM | 89.7954343 | ||
64 | 4/14/2011 | 10:00:00 AM | 89.75527056 | ||
65 | 4/14/2011 | 11:00:00 AM | 89.75959098 | ||
66 | 4/14/2011 | 12:00:00 PM | 89.74041897 | ||
67 | 4/14/2011 | 1:00:00 PM | 89.73745119 | ||
68 | 4/14/2011 | 2:00:00 PM | 89.72748286 | ||
69 | 4/14/2011 | 3:00:00 PM | 89.73357106 | ||
70 | 4/14/2011 | 4:00:00 PM | 89.73978163 | ||
71 | 4/14/2011 | 5:00:00 PM | 89.69373134 | ||
72 | 4/14/2011 | 6:00:00 PM | 89.69243007 | ||
73 | 4/14/2011 | 7:00:00 PM | 89.70108349 | ||
74 | 4/14/2011 | 8:00:00 PM | 89.69143145 | ||
75 | 4/14/2011 | 9:00:00 PM | 89.71144434 | ||
76 | 4/14/2011 | 10:00:00 PM | 89.68669843 | ||
77 | 4/14/2011 | 11:00:00 PM | 89.65879375 | ||
78 | 4/15/2011 | 12:00:00 AM | 89.62574137 | ||
79 | 4/15/2011 | 1:00:00 AM | 89.63699399 | ||
80 | 4/15/2011 | 2:00:00 AM | 89.60454973 | ||
81 | 4/15/2011 | 3:00:00 AM | 89.61356894 | ||
82 | 4/15/2011 | 4:00:00 AM | 89.61858809 | ||
83 | 4/15/2011 | 5:00:00 AM | 89.59192218 | ||
84 | 4/15/2011 | 6:00:00 AM | 89.65967075 | ||
85 | 4/15/2011 | 7:00:00 AM | 89.83517183 | ||
86 | 4/15/2011 | 8:00:00 AM | 89.80151035 | ||
87 | 4/15/2011 | 9:00:00 AM | 89.75513664 | ||
88 | 4/15/2011 | 10:00:00 AM | 89.68092351 | ||
89 | 4/15/2011 | 11:00:00 AM | 89.66758129 | ||
90 | 4/15/2011 | 12:00:00 PM | 89.51657856 | ||
91 | 4/15/2011 | 1:00:00 PM | 89.51700686 | ||
92 | 4/15/2011 | 2:00:00 PM | 89.23626623 | ||
93 | 4/15/2011 | 3:00:00 PM | 89.21921134 | ||
94 | 4/15/2011 | 4:00:00 PM | 89.32373699 | ||
95 | 4/15/2011 | 5:00:00 PM | 89.33945197 | ||
96 | 4/15/2011 | 6:00:00 PM | 89.3443829 | ||
97 | 4/15/2011 | 7:00:00 PM | 89.34052176 | ||
98 | 4/15/2011 | 8:00:00 PM | 89.35225468 | ||
99 | 4/15/2011 | 9:00:00 PM | 89.35955171 | ||
100 | 4/15/2011 | 10:00:00 PM | 89.36179366 | ||
Sheet1 |