Spreadsheet: 710413d1608935959-how-to-display-a-mode-from-an-adjacent-set-of-values-example
Sheet: Dec

 |  | December 2020 Weather Data - Magrathea |  |  |  |  |  |  | Wind Bearing | Frequency
 |  |  |  |  |  |  |  |  | N
Rain Data |  |  | Temperature Data |  |  | Wind Data |  |  | NNE
Total Rain (mm) |  |  | Min Temp  (°C) |  |  | [NAME] (km/h) |  |  | NE
[NAME] (mm/h) |  |  | [NAME]  (°C) |  |  | [NAME] (km/h) |  |  | ENE
High Hourly Rain (mm) |  |  | [NAME] (°C) |  |  | High Wind (km/h) |  |  | E
High Daily Rain (mm) |  |  | Highest Low Temp  (°C) |  |  | [NAME] (km/h) |  |  | ESE
Rain Days |  |  | Lowest High Temp  (°C) |  |  | Wind Run (Km) |  |  | SE
Dry Days |  |  | Max Apparent Temp  (°C) |  |  | Avg Daily Wind Run (km) |  |  | SSE
Humidity Data |  |  | Min Apparent Temp  (°C) |  |  | [NAME] speed (km/h) |  |  | S
Avg Relative Humidity (%) |  |  | Low Wind Chill  (°C) |  |  | Direction Mode |  |  | SSW
Solar Data |  |  | High Dew Point  (°C) |  |  | Barometric Data |  |  | SW
Sunshine Hours |  |  | [NAME]  (°C) |  |  | Min Pressure (hPa) |  |  | WSW
[NAME] (w/m²) |  |  | Avg Heating Degree Days (°C) |  |  | [NAME] (hPa) |  |  | W
Average Max UV |  |  | [NAME] (°C) |  |  | Avg Pressure (hPa) |  |  | WNW
 |  |  |  |  |  |  |  |  | NW
 |  |  |  |  |  |  |  |  | NNW
Date | Highest wind gust | Bearing of highest wind gust | Time of highest wind gust | Minimum temperature | Time of minimum temperature | Maximum temperature | Time of maximum temperature | Minimum sea level pressure | Time of minimum pressure | Maximum sea level pressure | Time of maximum pressure | Maximum rainfall rate | Time of maximum rainfall rate | Total rainfall for the day | Average temperature for the day | Total wind run | Highest average wind speed | Time of highest average wind speed | Lowest humidity | Time of lowest humidity | Highest humidity | Time of highest humidity | Total evapotranspiration | Total hours of sunshine | High heat index | Time of high heat index | High apparent temperature | Time of high apparent temperature | Low apparent temperature | Time of low apparent temperature | High hourly rain | Time of high hourly rain | Low wind chill | Time of low wind chill | High dew point | Time of high dew point | Low dew point | Time of low dew point | Dominant wind bearing | Heating degree days | Cooling degree days | High solar radiation | Time of high solar radiation | High UV Index | Time of high UV Index
2020-12-01 00:00:00 | 56.2 | 225 | 08:52 | 8.2 | 23:54:00 | 14.9 | 00:23:00 | 995.5 | 00:23:00 | 1019.8 | 23:24:00 | 3 | 01:23 | 4.5 | 11.6 | 599.1 | 39.2 | 08:22:00 | 69 | 19:24:00 | 93 | 01:23:00 | 0 | 2.5 | 14.9 | 00:23 | 15.2 | 00:23 | 4.5 | 08:22:00 | 1.5 | 01:23 | 7.1 | 23:54:00 | 12.6 | 00:23:00 | 5 | 23:54:00 | 204 | 7.1 | 0 | 561 | 15:53 | 7 | 15:53
2020-12-02 00:00:00 | 23.4 | 315 | 21:54 | 5.4 | 03:54:00 | 19.7 | 12:54:00 | 1010.8 | 23:54:00 | 1019.8 | 00:24:00 | 0 | 00:24 | 0 | 13 | 183.4 | 19.4 | 21:54:00 | 50 | 22:53:00 | 92 | 21:54:00 | 0 | 9.5 | 19.7 | 12:54 | 18 | 14:54 | 3.1 | 03:54:00 | 0 | 00:24 | 4.3 | 04:24:00 | 12.1 | 14:54:00 | 3.7 | 05:54:00 | 6 | 5.5 | 0.1 | 1269 | 12:54 | 15 | 12:24
2020-12-03 00:00:00 | 61.2 | 270 | 12:24 | 12.3 | 23:23:00 | 23.8 | 17:53:00 | 1004.6 | 12:24:00 | 1012.4 | 23:23:00 | 0 | 00:24 | 0 | 18.7 | 398.7 | 45.4 | 11:54:00 | 16 | 05:24:00 | 71 | 23:23:00 | 0 | 13.4 | 23.8 | 17:53 | 22.2 | 18:23 | 10.3 | 05:54:00 | 0 | 00:24 | 12.3 | 23:23:00 | 12.1 | 09:54:00 | -8 | 05:24:00 | 286 | 1.1 | 1.6 | 1236 | 13:24 | 15 | 12:24
2020-12-04 00:00:00 | 39.2 | 270 | 08:33 | 9.8 | 04:23:00 | 22.5 | 16:24:00 | 1006.2 | 18:24:00 | 1012.5 | 00:23:00 | 0 | 00:23 | 0 | 16.4 | 349.2 | 30.6 | 08:33:00 | 34 | 15:54:00 | 77 | 20:54:00 | 0 | 13.2 | 22.5 | 16:24 | 18.1 | 12:24 | 5.5 | 05:23:00 | 0 | 00:23 | 7.8 | 05:23:00 | 8.9 | 20:54:00 | 1.6 | 07:53:00 | 285 | 3 | 1.1 | 1435 | 12:54 | 15 | 12:54
2020-12-05 00:00:00 | 40.3 | 270 | 23:53 | 10 | 06:24:00 | 22.7 | 14:53:00 | 1001.8 | 17:23:00 | 1008.5 | 00:24:00 | 0 | 00:24 | 0 | 16 | 254.5 | 29.5 | 17:53:00 | 34 | 12:53:00 | 73 | 06:24:00 | 0 | 8 | 22.7 | 14:53 | 20.8 | 14:53 | 7 | 23:53:00 | 0 | 00:24 | 10 | 06:24:00 | 8.1 | 08:18:00 | 3.8 | 02:54:00 | 299 | 3 | 0.7 | 1343 | 13:23 | 15 | 13:23
2020-12-06 00:00:00 | 40.3 | 270 | 00:23 | 10.8 | 06:23:00 | 24.2 | 14:53:00 | 1003 | 00:23:00 | 1011.8 | 20:53:00 | 0 | 00:23 | 0 | 15.8 | 214 | 29.5 | 00:23:00 | 34 | 12:23:00 | 88 | 23:53:00 | 0 | 9.6 | 24.2 | 14:53 | 21.9 | 13:53 | 6.6 | 05:23:00 | 0 | 00:23 | 8.8 | 05:23:00 | 11 | 15:23:00 | 4.5 | 02:53:00 | 263 | 3.1 | 0.7 | 1360 | 13:23 | 15 | 12:23
2020-12-07 00:00:00 | 50 | 315 | 09:24 | 11.6 | 00:54:00 | 25.8 | 14:24:00 | 1006.5 | 16:54:00 | 1010.9 | 00:24:00 | 0 | 00:24 | 0 | 20.6 | 426.1 | 39.2 | 09:24:00 | 27 | 05:24:00 | 90 | 00:54:00 | 0 | 5.5 | 25.8 | 14:24 | 23.3 | 18:54 | 10.5 | 00:54:00 | 0 | 00:24 | 11.3 | 00:54:00 | 14.2 | 19:54:00 | -0.9 | 04:54:00 | 312 | 1 | 3.3 | 1488 | 13:24 | 15 | 13:24
2020-12-08 00:00:00 | 46.4 | 315 | 17:41 | 18.7 | 22:24:00 | 26.7 | 16:54:00 | 1006 | 02:24:00 | 1009.1 | 00:24:00 | 0 | 00:24 | 0 | 22.7 | 325.1 | 33.1 | 14:24:00 | 41 | 17:42:00 | 75 | 22:24:00 | 0 | 7.6 | 26.8 | 16:54 | 25.8 | 16:24 | 17.6 | 04:24:00 | 0 | 00:24 | 18.7 | 22:24:00 | 17.1 | 11:54:00 | 11.4 | 17:42:00 | 295 | 0 | 4.5 | 1405 | 11:54 | 15 | 11:54
2020-12-09 00:00:00 | 33.1 | 315 | 12:24 | 17.9 | 05:54:00 | 27.6 | 13:24:00 | 1008.2 | 04:24:00 | 1009.5 | 10:54:00 | 0 | 00:24 | 0 | 22.8 | 240.3 | 24.5 | 09:54:00 | 38 | 13:24:00 | 77 | 04:24:00 | 0 | 9.6 | 27.2 | 13:24 | 25.9 | 14:24 | 17.4 | 05:54:00 | 0 | 00:24 | 17.9 | 05:54:00 | 16.2 | 18:54:00 | 11.9 | 08:54:00 | 323 | 0 | 4.5 | 1418 | 13:24 | 15 | 12:24
2020-12-10 00:00:00 | 47.9 | 315 | 12:53 | 16.3 | 05:53:00 | 27 | 11:53:00 | 1003.1 | 11:53:00 | 1009.1 | 00:23:00 | 0 | 00:23 | 0 | 21.1 | 269.8 | 42.8 | 12:53:00 | 30 | 12:23:00 | 94 | 05:53:00 | 0 | 12.6 | 26.8 | 11:53 | 28.3 | 09:53 | 15.5 | 23:54:00 | 0 | 00:23 | 16.3 | 05:53:00 | 18 | 09:23:00 | 7.8 | 12:23:00 | 304 | 0.3 | 3.1 | 1466 | 12:53 | 15 | 12:23
2020-12-11 00:00:00 | 69.8 | 270 | 18:38 | 11.1 | 03:54:00 | 23.7 | 12:24:00 | 1007.5 | 16:24:00 | 1011 | 23:54:00 | 0 | 00:24 | 0 | 17.6 | 438.1 | 54 | 18:38:00 | 30 | 12:51:00 | 60 | 03:54:00 | 0 | 13.3 | 23.7 | 12:24 | 19.5 | 10:54 | 2.4 | 22:24:00 | 0 | 00:24 | 9.7 | 23:54:00 | 10.6 | 16:54:00 | -2 | 22:24:00 | 295 | 2 | 1.3 | 1269 | 12:52 | 15 | 12:51
2020-12-12 00:00:00 | 70.9 | 270 | 08:16 | 10.9 | 23:24:00 | 20.1 | 16:54:00 | 1009.7 | 02:24:00 | 1014.7 | 22:54:00 | 0 | 00:24 | 0 | 15.2 | 525.2 | 56.2 | 08:16:00 | 33 | 16:54:00 | 61 | 23:24:00 | 0 | 11.6 | 20.1 | 16:54 | 17 | 16:54 | 1.3 | 08:16:00 | 0 | 00:24 | 8.1 | 02:24:00 | 8.4 | 12:54:00 | 0.2 | 00:24:00 | 283 | 3.4 | 0.3 | 1503 | 11:54 | 15 | 11:54
2020-12-13 00:00:00 | 27 | 360 | 02:54 | 10.2 | 23:54:00 | 22.7 | 12:24:00 | 1012.1 | 02:54:00 | 1021.6 | 22:54:00 | 0.6 | 16:24 | 0.3 | 14.1 | 235.8 | 23.4 | 02:54:00 | 45 | 12:24:00 | 92 | 16:24:00 | 0 | 8.5 | 22.7 | 12:24 | 21.4 | 12:24 | 6 | 02:54:00 | 0.3 | 16:24 | 9.2 | 01:24:00 | 12.4 | 16:54:00 | 3.3 | 02:24:00 | 154 | 4.8 | 0.4 | 1454 | 12:24 | 15 | 12:24
2020-12-14 00:00:00 | 29.5 | 135 | 13:24 | 6.7 | 03:54:00 | 22.5 | 15:24:00 | 1021.2 | 15:54:00 | 1024.4 | 23:24:00 | 0 | 00:24 | 0 | 14.1 | 243.1 | 23.4 | 13:24:00 | 43 | 14:54:00 | 98 | 03:54:00 | 0 | 11.5 | 22.5 | 15:24 | 19.5 | 16:54 | 4.9 | 03:54:00 | 0 | 00:24 | 6 | 03:54:00 | 11.1 | 16:54:00 | 4.5 | 04:54:00 | 185 | 4.9 | 0.7 | 1272 | 13:24 | 15 | 12:54
2020-12-15 00:00:00 | 18.4 | 135 | 12:24 | 6.8 | 05:54:00 | 26.6 | 15:17:00 | 1019.1 | 23:25:00 | 1024.3 | 00:24:00 | 0 | 00:24 | 0 | 16.9 | 124.5 | 14.8 | 14:54:00 | 29 | 13:24:00 | 97 | 02:24:00 | 0 | 14.6 | 26.6 | 15:17 | 25.7 | 15:20 | 5.1 | 05:54:00 | 0 | 00:24 | 6.8 | 05:54:00 | 13.1 | 16:55:00 | 5.6 | 05:54:00 | 87 | 3.9 | 2.5 | 1348 | 13:24 | 15 | 12:54
2020-12-16 00:00:00 | 27 | 360 | 14:25 | 9.2 | 05:25:00 | 31.3 | 15:55:00 | 1013.1 | 16:25:00 | 1019.1 | 00:25:00 | 0 | 00:25 | 0 | 20.9 | 132.6 | 23.4 | 14:25:00 | 10 | 15:25:00 | 94 | 23:55:00 | 0 | 15.9 | 29.7 | 17:25 | 30.6 | 13:48 | 8.2 | 05:25:00 | 0 | 00:25 | 9.2 | 05:25:00 | 16.6 | 07:25:00 | -4.6 | 15:39:00 | 176 | 2.8 | 5.5 | 1402 | 13:24 | 15 | 12:55
2020-12-17 00:00:00 | 23.4 | 90 | 14:40 | 7.5 | 05:55:00 | 25.5 | 13:55:00 | 1015.1 | 03:25:00 | 1020.8 | 23:56:00 | 0 | 00:25 | 0 | 16.7 | 133.3 | 18.4 | 15:26:00 | 46 | 13:55:00 | 99 | 03:55:00 | 0 | 9.5 | 25.5 | 13:55 | 24.9 | 12:25 | 6.3 | 05:55:00 | 0 | 00:25 | 7.5 | 05:55:00 | 16.9 | 07:55:00 | 7.1 | 05:55:00 | 87 | 3.3 | 1.6 | 1419 | 13:25 | 15 | 12:55
2020-12-18 00:00:00 | 24.5 | 90 | 13:29 | 12.9 | 02:56:00 | 22.6 | 13:29:00 | 1016.5 | 18:25:00 | 1020.8 | 00:26:00 | 0 | 00:26 | 0 | 17.4 | 114.1 | 20.9 | 12:55:00 | 62 | 10:55:00 | 96 | 04:26:00 | 0 | 10.5 | 22.6 | 13:29 | 22.5 | 13:55 | 13.5 | 02:56:00 | 0 | 00:26 | 12.9 | 02:56:00 | 15.7 | 13:29:00 | 11.8 | 02:56:00 | 83 | 1.9 | 1 | 1374 | 12:25 | 15 | 12:25
2020-12-19 00:00:00 | 23.4 | 315 | 12:25 | 11.9 | 02:55:00 | 27.8 | 12:55:00 | 1013.3 | 17:55:00 | 1017.5 | 00:25:00 | 0 | 00:25 | 0 | 20.3 | 182.3 | 19.4 | 15:25:00 | 29 | 12:55:00 | 98 | 02:25:00 | 0 | 12.5 | 27.5 | 14:55 | 26.7 | 12:55 | 11.4 | 03:25:00 | 0 | 00:25 | 11.9 | 03:25:00 | 16.2 | 18:55:00 | 7.9 | 11:25:00 | 6 | 1.4 | 3.4 | 1344 | 13:55 | 15 | 13:25
2020-12-20 00:00:00 | 20.9 | 315 | 01:25 | 9.4 | 04:55:00 | 28.7 | 11:55:00 | 1012.9 | 04:55:00 | 1017.8 | 23:25:00 | 0 | 00:25 | 0 | 20 | 149.2 | 13.3 | 01:25:00 | 29 | 12:15:00 | 95 | 05:55:00 | 0 | 12.5 | 27.9 | 14:55 | 27.6 | 14:55 | 8.5 | 04:55:00 | 0 | 00:25 | 9.4 | 04:55:00 | 15.7 | 07:25:00 | 8.1 | 12:15:00 | 112 | 1.8 | 3.6 | 1706 | 12:15 | 15 | 12:15
2020-12-21 00:00:00 | 18.4 | 90 | 10:55 | 12.7 | 04:55:00 | 22.7 | 13:55:00 | 1014.9 | 17:55:00 | 1018 | 09:25:00 | 0 | 00:25 | 0 | 17.7 | 119.9 | 14.8 | 16:55:00 | 56 | 10:55:00 | 93 | 23:55:00 | 0 | 5.5 | 22.7 | 13:55 | 23.5 | 13:55 | 12.1 | 04:55:00 | 0 | 00:25 | 12.7 | 04:55:00 | 15.3 | 17:25:00 | 11.1 | 01:25:00 | 73 | 1.8 | 1.2 | 1113 | 15:55 | 11 | 12:55
2020-12-22 00:00:00 | 31.7 | 180 | 16:25 | 14.3 | 04:25:00 | 27.7 | 13:55:00 | 1009.3 | 18:55:00 | 1015.1 | 00:25:00 | 0 | 00:25 | 0 | 19.3 | 146 | 24.5 | 15:55:00 | 29 | 13:55:00 | 97 | 05:25:00 | 0 | 6 | 26.8 | 13:55 | 25.4 | 13:55 | 15.1 | 03:55:00 | 0 | 00:25 | 14.3 | 04:25:00 | 16.4 | 07:55:00 | 7.9 | 14:25:00 | 272 | 1.3 | 2.3 | 1850 | 12:25 | 15 | 12:55
2020-12-23 00:00:00 | 15.8 | 315 | 19:55 | 15.3 | 00:25:00 | 25.3 | 14:55:00 | 1002.2 | 23:55:00 | 1010.9 | 00:25:00 | 0.6 | 20:55 | 0.3 | 20.4 | 105.2 | 11.2 | 19:55:00 | 41 | 14:55:00 | 91 | 00:25:00 | 0 | 2 | 25.3 | 14:55 | 25.4 | 14:55 | 15.8 | 00:25:00 | 0.3 | 20:55 | 15.3 | 00:25:00 | 15.1 | 21:25:00 | 10.8 | 02:55:00 | 340 | 0.3 | 2.5 | 832 | 12:55 | 9 | 12:55
2020-12-24 00:00:00 | 36.7 | 315 | 13:15 | 15 | 23:57:00 | 23.9 | 11:56:00 | 993.7 | 12:56:00 | 1002.2 | 00:25:00 | 10.8 | 13:20 | 6.3 | 19.2 | 243 | 29.5 | 13:16:00 | 47 | 16:57:00 | 95 | 05:55:00 | 0 | 10.1 | 23.9 | 11:56 | 23.7 | 11:26 | 12.1 | 22:27:00 | 2.1 | 13:20 | 15 | 23:57:00 | 17.3 | 07:21:00 | 10.2 | 23:57:00 | 284 | 0.8 | 1.8 | 1246 | 14:27 | 15 | 14:27
2020-12-25 00:00:00 | 24.5 | 315 | 04:57 | 11.1 | 03:27:00 | 26.3 | 12:26:00 | 1000 | 00:27:00 | 1008.6 | 22:26:00 | 0 | 00:27 | 0 | 17.9 | 186.1 | 18.4 | 16:26:00 | 35 | 12:26:00 | 88 | 03:27:00 | 0 | 9 | 26.3 | 12:26 | 24.4 | 12:26 | 10.2 | 03:27:00 | 0 | 00:27 | 11.1 | 03:27:00 | 13.6 | 17:56:00 | 6 | 10:56:00 | 17 | 1.9 | 1.5 | 1646 | 12:26 | 15 | 11:56