Spreadsheet: 40617d1239019554-autofilter-problem-forumexample
Sheet: hourly

day | time | lowertemp | lowermax | lowermin | uppertemp | uppermax | uppermin
90 | 12:00:00 | 4.0427 | 4.23994 | 4.0427 | 0.84213 | 2.04043 | 0.84213
90 | 01:00:00 | 3.66053 | 3.83898 | 3.66053 | -0.49829 | 0.62369 | -0.62324
90 | 02:00:00 | 3.20673 | 3.40888 | 3.20673 | 0.24807 | 0.24807 | -1.77869
90 | 03:00:00 | 3.0407 | 3.09862 | 3.0407 | 0.22275 | 0.77463 | -0.01673
90 | 04:00:00 | 2.84683 | 2.95832 | 2.84683 | -0.15828 | 0.08487 | -0.5287
90 | 05:00:00 | 2.61112 | 2.71988 | 2.61112 | -0.12963 | -0.07554 | -0.67297
90 | 06:00:00 | 2.36089 | 2.49455 | 2.36089 | -0.39115 | 0.39035 | -0.47108
90 | 07:00:00 | 2.04506 | 2.17155 | 2.04506 | -0.18695 | -0.18695 | -0.79504
90 | 08:00:00 | 1.63176 | 1.81779 | 1.63176 | 2.64484 | 2.64484 | 1.14276
90 | 09:00:00 | 1.77907 | 1.77907 | 1.6271 | 8.76503 | 8.78384 | 6.03135
90 | 10:00:00 | 2.60039 | 2.60039 | 2.09136 | 31.15301 | 32.01703 | 10.02741
90 | 11:00:00 | 4.10297 | 4.10297 | 3.31927 | 15.27497 | 15.78442 | 14.56015
90 | 12:00:00 | 5.11727 | 5.11727 | 4.66014 | 15.41224 | 15.41224 | 14.18769
90 | 01:00:00 | 5.93083 | 5.93083 | 5.55898 | 15.56507 | 16.0349 | 14.52192
90 | 02:00:00 | 6.6987 | 6.6987 | 6.34415 | 16.69308 | 17.49761 | 15.86225
90 | 03:00:00 | 7.31264 | 7.31264 | 7.22345 | 18.12723 | 18.12723 | 15.94716
90 | 04:00:00 | 7.4193 | 7.4193 | 7.38863 | 16.56991 | 17.34882 | 15.93159
90 | 05:00:00 | 7.4047 | 7.42952 | 7.4047 | 14.70456 | 15.95282 | 14.23444
90 | 06:00:00 | 7.25709 | 7.35795 | 7.25709 | 12.08261 | 13.22087 | 11.24438
90 | 07:00:00 | 6.94817 | 7.14005 | 6.94817 | 9.10317 | 10.59381 | 9.10317
90 | 08:00:00 | 6.44577 | 6.70899 | 6.44577 | 5.38372 | 6.60906 | 5.38372
90 | 09:00:00 | 5.88941 | 6.14949 | 5.88941 | 4.56726 | 5.34654 | 4.56726
90 | 10:00:00 | 5.40601 | 5.63167 | 5.40601 | 4.39173 | 4.57775 | 4.0427
90 | 11:00:00 | 4.97857 | 5.18134 | 4.97857 | 3.53177 | 3.75282 | 3.30255
91 | 12:00:00 | 4.57625 | 4.77537 | 4.57625 | 2.58046 | 3.35117 | 2.27782
91 | 01:00:00 | 4.19631 | 4.3692 | 4.19631 | 2.12067 | 2.98884 | 1.70157
91 | 02:00:00 | 3.9009 | 4.03968 | 3.9009 | 1.12088 | 3.05594 | 1.12088
91 | 03:00:00 | 3.51206 | 3.71501 | 3.51206 | 0.62841 | 0.72121 | -0.5207
91 | 04:00:00 | 3.19456 | 3.34206 | 3.19456 | -0.37677 | 0.36508 | -0.6842
91 | 05:00:00 | 3.01019 | 3.06509 | 3.01019 | 1.94774 | 2.08982 | 1.31755
91 | 06:00:00 | 2.96137 | 2.99189 | 2.96137 | 1.43126 | 1.84411 | 1.23177
91 | 07:00:00 | 2.86516 | 2.90946 | 2.86516 | 1.43748 | 1.88589 | 1.15526
91 | 08:00:00 | 2.85447 | 2.85447 | 2.83154 | 5.85982 | 5.85982 | 3.70593
91 | 09:00:00 | 3.30103 | 3.30103 | 3.00104 | 9.81046 | 9.85933 | 8.02982
91 | 10:00:00 | 4.18578 | 4.18578 | 3.7135 | 13.7867 | 13.97093 | 12.09827
91 | 11:00:00 | 5.26323 | 5.26323 | 4.729 | 17.55714 | 17.55714 | 13.83914
91 | 12:00:00 | 6.48257 | 6.48257 | 5.84058 | 19.82534 | 19.85671 | 16.2302
91 | 01:00:00 | 7.50252 | 7.50252 | 7.04342 | 18.42815 | 20.608 | 17.16323
91 | 02:00:00 | 8.04435 | 8.04435 | 7.85961 | 19.34801 | 19.34801 | 14.74278
91 | 03:00:00 | 8.45805 | 8.45805 | 8.40441 | 17.10799 | 21.14939 | 17.10799
91 | 04:00:00 | 8.34349 | 8.44935 | 8.34349 | 18.69804 | 19.79824 | 15.51696
91 | 05:00:00 | 8.21723 | 8.25788 | 8.21723 | 15.01031 | 18.5304 | 13.21661
91 | 06:00:00 | 8.1359 | 8.16205 | 8.1359 | 13.2379 | 16.11981 | 13.2379
91 | 07:00:00 | 7.90037 | 8.06616 | 7.90037 | 10.452 | 12.2363 | 10.452
91 | 08:00:00 | 7.36525 | 7.679 | 7.36525 | 5.47287 | 7.52003 | 5.47287
91 | 09:00:00 | 6.58407 | 6.94963 | 6.58407 | 3.25237 | 5.66281 | 2.33321
91 | 10:00:00 | 5.89829 | 6.21589 | 5.89829 | 3.71652 | 4.53428 | 3.71047
91 | 11:00:00 | 5.23644 | 5.59459 | 5.23644 | 0.01662 | 1.70622 | -0.3145
92 | 12:00:00 | 4.35719 | 4.78136 | 4.35719 | -1.409 | -0.68902 | -1.66608
92 | 01:00:00 | 3.76492 | 3.99596 | 3.76492 | -0.05964 | 0.02774 | -0.89159
92 | 02:00:00 | 3.56966 | 3.59996 | 3.56966 | 0.5481 | 1.53546 | 0.52761
92 | 03:00:00 | 3.59087 | 3.59087 | 3.54844 | 2.47459 | 2.55592 | 1.60537
92 | 04:00:00 | 3.67718 | 3.67718 | 3.64691 | 2.43773 | 2.45156 | 2.35013
92 | 05:00:00 | 3.69837 | 3.69837 | 3.69383 | 2.7719 | 2.81625 | 2.57586
92 | 06:00:00 | 3.71047 | 3.71047 | 3.70442 | 3.00409 | 3.00409 | 2.85752
92 | 07:00:00 | 3.75585 | 3.75585 | 3.72711 | 3.61511 | 3.61511 | 3.0849
92 | 08:00:00 | 3.89788 | 3.89788 | 3.82538 | 3.842 | 4.1346 | 3.76038
92 | 09:00:00 | 4.06078 | 4.06078 | 3.97937 | 3.68475 | 3.95221 | 3.61662
92 | 10:00:00 | 4.31962 | 4.31962 | 4.1617 | 5.67171 | 5.77395 | 4.20534
92 | 11:00:00 | 4.78883 | 4.78883 | 4.52678 | 7.63089 | 10.98866 | 5.79468
92 | 12:00:00 | 5.13814 | 5.13963 | 5.00244 | 6.68842 | 8.35075 | 6.48698
92 | 01:00:00 | 5.53226 | 5.53226 | 5.45653 | 12.01997 | 12.01997 | 7.9702
92 | 02:00:00 | 6.15392 | 6.18638 | 5.78876 | 11.10727 | 16.43402 | 9.72418
92 | 03:00:00 | 5.84354 | 6.086 | 5.84354 | 6.78094 | 7.33457 | 6.06237
92 | 04:00:00 | 5.59163 | 5.66874 | 5.59163 | 6.91738 | 7.70378 | 6.17163
92 | 05:00:00 | 5.34357 | 5.47584 | 5.34357 | 5.4803 | 6.15834 | 5.34357
92 | 06:00:00 | 5.06808 | 5.15453 | 5.06808 | 6.73249 | 8.61741 | 5.24984
92 | 07:00:00 | 4.73648 | 4.93229 | 4.73648 | 3.73165 | 5.13963 | 3.73165
92 | 08:00:00 | 4.36019 | 4.55227 | 4.36019 | 2.91557 | 2.98426 | 2.78414
92 | 09:00:00 | 3.92354 | 4.13158 | 3.92354 | 2.24395 | 2.80555 | 2.24395
92 | 10:00:00 | 3.5257 | 3.74073 | 3.5257 | -0.30652 | 1.45927 | -0.46309
92 | 11:00:00 | 3.21434 | 3.34054 | 3.21434 | 1.24426 | 1.44682 | 1.09431
93 | 12:00:00 | 2.91863 | 3.07423 | 2.91863 | 0.30502 | 1.32223 | 0.16256
93 | 01:00:00 | 2.59119 | 2.71988 | 2.59119 | -0.35121 | 0.13403 | -0.35121
93 | 02:00:00 | 2.25165 | 2.46231 | 2.25165 | -2.47375 | -2.19013 | -3.57535
93 | 03:00:00 | 2.01418 | 2.10679 | 2.01418 | -0.77093 | -0.62805 | -3.15719
93 | 04:00:00 | 1.91063 | 1.96783 | 1.91063 | -1.14006 | -0.28578 | -1.14006
93 | 05:00:00 | 1.76513 | 1.8503 | 1.76358 | -1.32787 | -1.15299 | -2.81029
93 | 06:00:00 | 1.68606 | 1.73878 | 1.68606 | -1.51138 | -1.51138 | -2.69402
93 | 07:00:00 | 1.5712 | 1.65348 | 1.5712 | -3.01851 | -2.81029 | -3.29958
93 | 08:00:00 | 1.54478 | 1.54478 | 1.5308 | 5.23793 | 5.26919 | 2.35782
93 | 09:00:00 | 1.77597 | 1.77597 | 1.59605 | 10.93005 | 11.05154 | 6.86018
93 | 10:00:00 | 2.54979 | 2.54979 | 2.14534 | 12.97674 | 13.72008 | 11.63103
93 | 11:00:00 | 4.264 | 4.264 | 3.29951 | 15.61036 | 17.61809 | 15.10231
93 | 12:00:00 | 6.6267 | 6.6267 | 5.4595 | 22.78115 | 25.17488 | 18.65967
93 | 01:00:00 | 8.87638 | 8.87638 | 8.0429 | 19.37934 | 21.18812 | 17.86196
93 | 02:00:00 | 10.47779 | 10.55944 | 9.35559 | 22.95777 | 23.38712 | 21.08774
93 | 03:00:00 | 10.26564 | 10.55084 | 10.26564 | 22.50646 | 23.87597 | 19.7127
93 | 04:00:00 | 9.56878 | 9.87514 | 9.56878 | 21.01894 | 22.15436 | 19.66852
93 | 05:00:00 | 9.07141 | 9.35991 | 9.07141 | 17.86905 | 21.21537 | 16.27691
93 | 06:00:00 | 8.81421 | 8.88794 | 8.80987 | 15.87498 | 18.0421 | 15.47451
93 | 07:00:00 | 8.05162 | 8.55224 | 8.05162 | 9.73712 | 12.21923 | 9.73712
93 | 08:00:00 | 6.73542 | 7.5069 | 6.73542 | 4.39924 | 4.89495 | 4.16772
93 | 09:00:00 | 5.50257 | 6.08157 | 5.50257 | 1.42503 | 3.11233 | 1.42503
93 | 10:00:00 | 4.49979 | 5.05018 | 4.49979 | 2.99494 | 3.88429 | 2.60193
93 | 11:00:00 | 3.89637 | 4.29558 | 3.89637 | 2.51143 | 2.68619 | 0.3398
94 | 12:00:00 | 3.51661 | 3.69686 | 3.51661 | 1.31755 | 2.35321 | 0.3319
94 | 01:00:00 | 3.1565 | 3.32079 | 3.1565 | 0.7762 | 1.83327 | 0.01186
94 | 02:00:00 | 2.81778 | 3.00714 | 2.81778 | -2.66747 | -1.24199 | -3.53996
94 | 03:00:00 | 2.53752 | 2.63564 | 2.53752 | -3.53154 | -0.99795 | -3.53154
94 | 04:00:00 | 2.30552 | 2.43313 | 2.30552 | -2.06689 | -1.73134 | -4.41293
94 | 05:00:00 | 2.09445 | 2.20083 | 2.09445 | -2.039 | 0.38877 | -2.14738
94 | 06:00:00 | 1.99564 | 2.06204 | 1.99564 | -1.75256 | -0.30811 | -2.73219
94 | 07:00:00 | 1.84565 | 1.9029 | 1.84565 | 0.37772 | 0.5985 | -3.22248
94 | 08:00:00 | 1.50592 | 1.74808 | 1.50592 | 9.70117 | 9.70117 | 7.80866
94 | 09:00:00 | 3.76341 | 3.76341 | 2.25011 | 15.55941 | 15.55941 | 12.83758
94 | 10:00:00 | 5.7221 | 5.7221 | 4.95767 | 22.5108 | 23.01137 | 16.74546
94 | 11:00:00 | 7.01998 | 7.01998 | 6.45166 | 26.45182 | 28.76885 | 22.18031
94 | 12:00:00 | 8.23756 | 8.23756 | 7.61777 | 29.85631 | 33.37282 | 26.50986
94 | 01:00:00 | 9.96853 | 9.96853 | 9.14358 | 28.7993 | 31.82578 | 26.94095
94 | 02:00:00 | 11.3229 | 11.34288 | 10.71835 | 30.59458 | 32.5379 | 26.48902
94 | 03:00:00 | 12.43116 | 12.46954 | 12.14666 | 28.85719 | 28.85719 | 25.25291
94 | 04:00:00 | 12.90433 | 12.92705 | 12.78929 | 23.35081 | 26.69163 | 23.22597
94 | 05:00:00 | 12.839 | 12.90575 | 12.83048 | 21.47949 | 23.54116 | 20.92293
94 | 06:00:00 | 12.54915 | 12.7836 | 12.54915 | 17.72583 | 20.09071 | 17.48486
94 | 07:00:00 | 11.23153 | 11.9032 | 11.23153 | 13.98369 | 16.63361 | 13.91142
94 | 08:00:00 | 9.04831 | 10.24412 | 9.04831 | 5.34654 | 6.76185 | 5.0099
94 | 09:00:00 | 7.09906 | 7.91928 | 7.09906 | 3.84955 | 5.26621 | 3.84955
94 | 10:00:00 | 6.03578 | 6.62817 | 6.03578 | 5.10386 | 5.30192 | 3.87523
94 | 11:00:00 | 5.39858 | 5.63761 | 5.39858 | 3.8148 | 4.85461 | 3.43469
95 | 12:00:00 | 4.75742 | 5.02632 | 4.75742 | 2.89877 | 3.51812 | 2.40854
95 | 01:00:00 | 3.86768 | 4.30459 | 3.86768 | 2.25473 | 2.30552 | 1.89362
95 | 02:00:00 | 3.74678 | 3.74678 | 3.69988 | 3.77097 | 3.92656 | 2.76272
95 | 03:00:00 | 3.58936 | 3.81631 | 3.5833 | 2.59426 | 2.6816 | 1.59139
95 | 04:00:00 | 3.54541 | 3.60753 | 3.54389 | 1.9771 | 2.69844 | 1.08805
95 | 05:00:00 | 3.32534 | 3.40129 | 3.32534 | -1.43661 | 2.11604 | -1.43661
95 | 06:00:00 | 2.72906 | 3.06661 | 2.72906 | -0.35441 | -0.30173 | -2.04884
95 | 07:00:00 | 2.41623 | 2.51143 | 2.41623 | 1.05521 | 1.05521 | -2.29056
95 | 08:00:00 | 2.66628 | 2.66628 | 2.42852 | 6.17458 | 6.33236 | 2.79026
95 | 09:00:00 | 3.94165 | 3.94165 | 3.15954 | 16.89555 | 16.89555 | 11.85905
95 | 10:00:00 | 5.80505 | 5.80505 | 4.88449 | 16.91113 | 19.18433 | 15.27072
95 | 11:00:00 | 6.97309 | 6.97309 | 6.44577 | 19.95942 | 20.93583 | 17.08249
95 | 12:00:00 | 8.50153 | 8.51602 | 7.70232 | 25.83602 | 25.83602 | 21.07054
95 | 01:00:00 | 10.13651 | 10.16952 | 9.20707 | 24.87647 | 29.30174 | 21.52546
95 | 02:00:00 | 11.45846 | 11.50126 | 11.13727 | 23.80749 | 26.13683 | 21.97137
95 | 03:00:00 | 11.76501 | 11.82485 | 11.6795 | 21.89074 | 27.95479 | 21.36318
95 | 04:00:00 | 11.60679 | 11.68092 | 11.57542 | 22.81732 | 25.90708 | 20.41067
95 | 05:00:00 | 11.50839 | 11.60109 | 11.4442 | 20.81266 | 24.96019 | 20.67238
95 | 06:00:00 | 11.17012 | 11.54833 | 11.17012 | 16.28681 | 21.40051 | 16.05471
95 | 07:00:00 | 9.79177 | 10.56373 | 9.79177 | 12.20215 | 14.72438 | 11.91317
95 | 08:00:00 | 7.54921 | 8.78817 | 7.54921 | 3.97635 | 6.26161 | 3.92656
95 | 09:00:00 | 5.95449 | 6.42074 | 5.95449 | 2.19158 | 3.39674 | 1.92455
95 | 10:00:00 | 5.05316 | 5.53078 | 5.05316 | 1.62244 | 1.68451 | 0.12611
95 | 11:00:00 | 4.08941 | 4.50579 | 4.08941 | 0.83742 | 3.04527 | 0.83742
96 | 12:00:00 | 3.45745 | 3.68324 | 3.45745 | -2.28232 | 1.53857 | -2.28232
96 | 01:00:00 | 3.03765 | 3.30103 | 3.03765 | -3.49786 | -2.47375 | -3.93052
96 | 02:00:00 | 2.726 | 2.75048 | 2.726 | -3.38687 | -0.60079 | -3.38687
96 | 03:00:00 | 2.37627 | 2.55899 | 2.37627 | -3.10034 | 0.10391 | -3.27275
96 | 04:00:00 | 2.16846 | 2.21777 | 2.1623 | -2.6625 | 0.49451 | -2.6625
96 | 05:00:00 | 2.00337 | 2.1037 | 1.96938 | 0.18949 | 0.52604 | -1.23065
96 | 06:00:00 | 1.92455 | 2.00646 | 1.92455 | 1.84411 | 2.36089 | 0.5922
96 | 07:00:00 | 2.07284 | 2.07284 | 1.93074 | 4.51028 | 4.51028 | 1.5976
96 | 08:00:00 | 2.48687 | 2.48687 | 2.15613 | 10.39611 | 10.75412 | 7.36964
96 | 09:00:00 | 3.68929 | 3.68929 | 3.06204 | 17.89458 | 19.67279 | 13.84481
96 | 10:00:00 | 5.40155 | 5.40155 | 4.57175 | 17.77688 | 19.97083 | 17.77688
96 | 11:00:00 | 6.9555 | 6.9555 | 6.21736 | 20.58368 | 21.45508 | 18.40827
96 | 12:00:00 | 9.0122 | 9.0122 | 7.99056 | 22.48046 | 29.98431 | 21.11355
96 | 01:00:00 | 10.62387 | 10.63246 | 9.96566 | 22.19329 | 27.2478 | 15.30752
96 | 02:00:00 | 11.55261 | 11.55261 | 11.11584 | 25.69256 | 26.4057 | 17.43384
96 | 03:00:00 | 11.78781 | 12.20784 | 11.78781 | 17.77404 | 20.05931 | 13.67472
96 | 04:00:00 | 11.64956 | 11.72083 | 11.59824 | 13.92559 | 27.79792 | 13.92559
96 | 05:00:00 | 10.92004 | 11.29149 | 10.92004 | 19.39642 | 19.39642 | 12.57474
96 | 06:00:00 | 10.80134 | 10.9758 | 10.80134 | 12.97816 | 14.89849 | 12.58611
96 | 07:00:00 | 10.14082 | 10.47922 | 10.14082 | 12.35294 | 13.41239 | 11.20154
96 | 08:00:00 | 8.68545 | 9.58605 | 8.68545 | 2.54212 | 5.69543 | 1.63797
96 | 09:00:00 | 6.69724 | 7.51857 | 6.69724 | -1.06251 | 0.55598 | -1.06251
96 | 10:00:00 | 5.47881 | 6.00475 | 5.47881 | -0.6489 | 0.93621 | -0.6489
96 | 11:00:00 | 4.66763 | 5.03974 | 4.66763 | -2.22469 | -0.67939 | -2.66084