Spreadsheet: 807755d1670022907-my-formula-fails-to-select-smallest-8-from-last-20-entries-then-average-them-average-index-sort-filter-sequence-formula-not-working
Sheet: Sheet1

Column1 | Column2
2019-11-23 00:00:00 | 20.76046511627907
2020-01-05 00:00:00 | 17.25658914728682
2020-01-15 00:00:00 | 20.76046511627907
2020-01-19 00:00:00 | 16.38062015503876
2020-01-30 00:00:00 | 13.75271317829458
2020-02-12 00:00:00 | 18.13255813953489
2020-02-15 00:00:00 | 19.88449612403101
2020-02-19 00:00:00 | 12.87674418604651
2020-02-26 00:00:00 | 15.5046511627907
2020-03-01 00:00:00 | 17.25658914728682
2020-03-04 00:00:00 | 15.5046511627907
2020-03-07 00:00:00 | 20.76046511627907
2020-03-11 00:00:00 | 19.88449612403101
2020-03-18 00:00:00 | 14.62868217054264
2020-03-21 00:00:00 | 9.372868217054267
2020-03-25 00:00:00 | 14.62868217054264
2020-04-22 00:00:00 | 19.00852713178295
2020-04-24 00:00:00 | 17.49043478260869
2020-04-28 00:00:00 | 14.54260869565217
2020-05-02 00:00:00 | 18.47304347826087
2020-11-04 00:00:00 | 25.35130434782608
2020-11-06 00:00:00 | 29.28173913043478
2020-11-13 00:00:00 | 27.31652173913043
2020-11-18 00:00:00 | 32.2295652173913
2020-11-25 00:00:00 | 20.66576576576576
2020-11-27 00:00:00 | 19.64774774774775
2020-12-02 00:00:00 | 25.75585585585585
2020-12-04 00:00:00 | 19.64774774774775
2020-12-16 00:00:00 | 24.73783783783784
2020-12-18 00:00:00 | 22.7018018018018
2021-01-23 00:00:00 | 18.62972972972973
2020-12-30 00:00:00 | 20.66576576576576
2021-01-01 00:00:00 | 21.68378378378378
2021-01-06 00:00:00 | 10.48558558558558
2021-01-09 00:00:00 | 21.68378378378378
2021-01-13 00:00:00 | 25.75585585585585
2021-01-15 00:00:00 | 16.59369369369369
2021-01-18 00:00:00 | 24.84132231404958
2021-01-20 00:00:00 | 29.82792792792793
2021-01-22 00:00:00 | 15.57567567567567
2021-02-01 00:00:00 | 18.47304347826087
2021-02-05 00:00:00 | 19.64774774774775
2021-02-08 00:00:00 | 10.61217391304348
2021-02-10 00:00:00 | 17.61171171171171
2021-02-12 00:00:00 | 15.57567567567567
2021-02-17 00:00:00 | 18.47304347826087
2021-02-19 00:00:00 | 21.68378378378378
2021-02-24 00:00:00 | 19.64774774774775
2021-02-26 00:00:00 | 20.66576576576576
2021-03-03 00:00:00 | 8.449549549549547
2021-03-05 00:00:00 | 15.57567567567567
2021-03-10 00:00:00 | 11.5036036036036
2021-03-11 00:00:00 | 15.57567567567567
2021-03-12 00:00:00 | 9.467567567567565
2021-03-17 00:00:00 | 22.7018018018018
2021-03-19 00:00:00 | 11.5036036036036
2021-03-24 00:00:00 | 21.68378378378378
2021-03-27 00:00:00 | 16.59369369369369
2021-03-31 00:00:00 | 22.7018018018018
2021-04-02 00:00:00 | 22.7018018018018
2021-04-12 00:00:00 | 18.62972972972973
2021-04-14 00:00:00 | 21.68378378378378
2021-04-16 00:00:00 | 20.66576576576576
2021-04-23 00:00:00 | 9.467567567567565
2021-04-28 00:00:00 | 18.62972972972973
2021-05-23 00:00:00 | 29.85083333333333
2021-05-31 00:00:00 | 26.08416666666667
2021-06-14 00:00:00 | 18.55083333333334
2021-06-28 00:00:00 | 27.9675
2021-07-12 00:00:00 | 23.25916666666667
2021-08-09 00:00:00 | 27.02583333333333
2021-08-23 00:00:00 | 37.38416666666667
2021-08-30 00:00:00 | 27.9675
2022-11-10 00:00:00 | 30.84594594594595
2022-11-12 00:00:00 | 17.61171171171171
2022-11-17 00:00:00 | 21.68378378378378
2022-11-19 00:00:00 | 19.64774774774775
2022-11-21 00:00:00 | 22.7018018018018
2022-11-24 00:00:00 | 28.80990990990991
2022-11-26 00:00:00 | 31.86396396396396
2022-12-01 00:00:00 | 29.82792792792793
2022-12-03 00:00:00 | 24.73783783783784
2022-12-05 00:00:00 | 15.57567567567567
2022-12-08 00:00:00 | 18.62972972972973
2022-12-10 00:00:00 | 20.66576576576576
2022-12-15 00:00:00 | 17.61171171171171
2022-12-17 00:00:00 | 18.62972972972973
2022-12-26 00:00:00 | 18.62972972972973
2022-12-29 00:00:00 | 26.77387387387387
2022-12-31 00:00:00 | 25.75585585585585
2022-01-05 00:00:00 | 17.61171171171171
2022-01-07 00:00:00 | 24.73783783783784
2022-01-12 00:00:00 | 25.75585585585585
2022-01-14 00:00:00 | 19.64774774774775
2022-01-19 00:00:00 | 15.57567567567567
2022-01-21 00:00:00 | 24.73783783783784
2022-01-23 00:00:00 | 19.64774774774775
2022-01-26 00:00:00 | 16.59369369369369
2022-02-02 00:00:00 | 21.68378378378378
2022-02-04 00:00:00 | 23.71981981981982
2022-02-05 00:00:00 | 15.57567567567567
2022-02-06 00:00:00 | 18.62972972972973
2022-02-11 00:00:00 | 18.62972972972973
2022-02-16 00:00:00 | 20.66576576576576
2022-02-18 00:00:00 | 16.59369369369369
2022-02-23 00:00:00 | 13.53963963963964
2022-02-25 00:00:00 | 27.79189189189189
2022-03-02 00:00:00 | 30.84594594594595
2022-03-05 00:00:00 | 25.75585585585585
2022-03-06 00:00:00 | 14.55765765765766
2022-03-16 00:00:00 | 25.75585585585585
2022-03-18 00:00:00 | 23.71981981981982
2022-03-22 00:00:00 | 17.61171171171171
2022-03-25 00:00:00 | 19.64774774774775
2022-03-30 00:00:00 | 21.68378378378378
2022-04-01 00:00:00 | 26.77387387387387
2022-04-03 00:00:00 | 17.61171171171171
2022-04-08 00:00:00 | 14.55765765765766
2022-04-13 00:00:00 | 18.62972972972973
2022-04-20 00:00:00 | 22.7018018018018
2022-10-19 00:00:00 | 28.80990990990991
2022-10-26 00:00:00 | 26.77387387387387
2022-10-28 00:00:00 | 23.71981981981982
2022-11-02 00:00:00 | 23.71981981981982
2022-11-30 00:00:00 | 25.75585585585585