Spreadsheet: 744377d1629207615-index-and-match-lookup-to-find-the-last-number-over-50-identifying-shifting-number-series-arniebun-
Sheet: Sheet2

 |  | 0 |  | C>=50,D<0 | C<50,D>0
 |  | 46.2
 |  | 50.2 | 4
 |  | 43.6 | -6.600000000000001
 |  | 37.4 | -6.200000000000003
 |  | 29.4 | -8
 |  | 30.3 | 0.9000000000000021
 |  | 35 | 4.699999999999999
 |  | 45.5 | 10.5
 |  | 50.1 | 4.600000000000001
 |  | 55.5 | 5.399999999999999
 |  | 58.2 | 2.700000000000003
 |  | 53 | -5.200000000000003
 |  | 49.2 | -3.799999999999997
 |  | 48.8 | -0.4000000000000057
 |  | 49.6 | 0.8000000000000043
 |  | 51.6 | 2
 |  | 53.5 | 1.899999999999999
 |  | 50.7 | -2.799999999999997
 |  | 46.7 | -4
 |  | 48.3 | 1.599999999999994
 |  | 42.5 | -5.799999999999997
 |  | 40 | -2.5
 |  | 36.1 | -3.899999999999999
 |  | 37.8 | 1.699999999999996
 |  | 38.2 | 0.4000000000000057
 |  | 38.3 | 0.09999999999999432
 |  | 36.8 | -1.5
 |  | 37.8 | 1
 |  | 35.5 | -2.299999999999997
 |  | 38.3 | 2.799999999999997
 |  | 38.4 | 0.1000000000000014
 |  | 38.3 | -0.1000000000000014
 |  | 38.8 | 0.5
 |  | 39.4 | 0.6000000000000014
 |  | 39.2 | -0.1999999999999957
 |  | 42.8 | 3.599999999999994
 |  | 46 | 3.200000000000003
 |  | 54.4 | 8.399999999999999
 |  | 53.9 | -0.5
 |  | 54.2 | 0.3000000000000043
 |  | 56.1 | 1.899999999999999
 |  | 57.5 | 1.399999999999999
 |  | 63.6 | 6.100000000000001
 |  | 63.1 | -0.5
 |  | 62.5 | -0.6000000000000014
 |  | 64.4 | 1.900000000000006
 |  | 66 | 1.599999999999994
 |  | 69.9 | 3.900000000000006
 |  | 60.5 | -9.400000000000006
 |  | 61.3 | 0.7999999999999972
 |  | 58.9 | -2.399999999999999
 |  | 61 | 2.100000000000001
 |  | 58.6 | -2.399999999999999
 |  | 58.1 | -0.5
 |  | 56.1 | -2
 |  | 53 | -3.100000000000001
 |  | 50 | -3
 |  | 50.8 | 0.7999999999999972
 |  | 50.3 | -0.5
 |  | 50.6 | 0.3000000000000043
 |  | 50.3 | -0.3000000000000043
 |  | 49.9 | -0.3999999999999986
 |  | 47.8 | -2.100000000000001
 |  | 48.2 | 0.4000000000000057
 |  | 47.1 | -1.100000000000001
 |  | 47.8 | 0.6999999999999957
 |  | 47.9 | 0.1000000000000014
 |  | 47.7 | -0.1999999999999957
 |  | 49.9 | 2.199999999999996
 |  | 50.9 | 1
 |  | 52 | 1.100000000000001
 |  | 50.7 | -1.299999999999997
 |  | 51.2 | 0.5
 |  | 51 | -0.2000000000000028
 |  | 51 | 0
 |  | 49.7 | -1.299999999999997
 |  | 53.4 | 3.699999999999996
 |  | 50.5 | -2.899999999999999
 |  | 48 | -2.5
 |  | 52.6 | 4.600000000000001
 |  | 52.4 | -0.2000000000000028
 |  | 51.2 | -1.199999999999996
 |  | 51.2 | 0
 |  | 50.5 | -0.7000000000000028
 |  | 54.9 | 4.399999999999999
 |  | 52.6 | -2.299999999999997
 |  | 55 | 2.399999999999999
 |  | 55.5 | 0.5
 |  | 57.2 | 1.700000000000003
 |  | 57.4 | 0.1999999999999957
 |  | 57.5 | 0.1000000000000014
 |  | 59.3 | 1.799999999999997
 |  | 60 | 0.7000000000000028
 |  | 60.7 | 0.7000000000000028
 |  | 58.8 | -1.900000000000006
 |  | 61 | 2.200000000000003
 |  | 57.5 | -3.5
 |  | 56.2 | -1.299999999999997
 |  | 54.6 | -1.600000000000001
 |  | 55.8 | 1.199999999999996
 |  | 55.5 | -0.2999999999999972
 |  | 59.3 | 3.799999999999997
 |  | 58.2 | -1.099999999999994
 |  | 56 | -2.200000000000003
 |  | 54.5 | -1.5
 |  | 55.4 | 0.8999999999999986
 |  | 55.6 | 0.2000000000000028
 |  | 56 | 0.3999999999999986
 |  | 54.7 | -1.299999999999997
 |  | 54.1 | -0.6000000000000014
 |  | 51.5 | -2.600000000000001
 |  | 52.2 | 0.7000000000000028
 |  | 49.3 | -2.900000000000006
 |  | 47.3 | -2
 |  | 45.9 | -1.399999999999999
 |  | 45.1 | -0.7999999999999972
 |  | 46 | 0.8999999999999986
 |  | 46.8 | 0.7999999999999972
 |  | 46.8 | 0
 |  | 47.4 | 0.6000000000000014
 |  | 47.2 | -0.1999999999999957
 |  | 49.1 | 1.899999999999999
 |  | 49.9 | 0.7999999999999972
 |  | 50 | 0.1000000000000014
 |  | 49.5 | -0.5
 |  | 49.2 | -0.2999999999999972
 |  | 46.6 | -2.600000000000001
 |  | 46.1 | -0.5
 |  | 44.5 | -1.600000000000001
 |  | 43.2 | -1.299999999999997
 |  | 41.3 | -1.900000000000006
 |  | 40.8 | -0.5
 |  | 39.2 | -1.599999999999994
 |  | 39.4 | 0.1999999999999957
 |  | 40.7 | 1.300000000000004
 |  | 42.8 | 2.099999999999994
 |  | 44.5 | 1.700000000000003
 |  | 50.3 | 5.799999999999997
 |  | 50.6 | 0.3000000000000043
 |  | 52.9 | 2.299999999999997
 |  | 54.9 | 2
 |  | 53.1 | -1.799999999999997
 |  | 49.5 | -3.600000000000001
 |  | 46.8 | -2.700000000000003
 |  | 47.3 | 0.5
 |  | 52.7 | 5.400000000000006
 |  | 54.6 | 1.899999999999999
 |  | 52.6 | -2
 |  | 55.7 | 3.100000000000001
 |  | 53.6 | -2.100000000000001
 |  | 53.9 | 0.2999999999999972
 |  | 53.4 | -0.5
 |  | 49.7 | -3.699999999999996
 |  | 50.3 | 0.5999999999999943
 |  | 53.6 | 3.300000000000004
 |  | 54.2 | 0.6000000000000014
 |  | 55.8 | 1.599999999999994
 |  | 55.2 | -0.5999999999999943
 |  | 53.5 | -1.700000000000003
 |  | 50.2 | -3.299999999999997
 |  | 51.2 | 1
 |  | 49.6 | -1.600000000000001
 |  | 50.2 | 0.6000000000000014
 |  | 50.7 | 0.5
 |  | 50.8 | 0.09999999999999432
 |  | 53.4 | 2.600000000000001
 |  | 53.8 | 0.3999999999999986
 |  | 55.6 | 1.800000000000004
 |  | 56 | 0.3999999999999986
 |  | 56.5 | 0.5
 |  | 56.9 | 0.3999999999999986
 |  | 57.4 | 0.5
 |  | 58.2 | 0.8000000000000043
 |  | 58.8 | 0.5999999999999943
 |  | 58.5 | -0.2999999999999972
 |  | 58 | -0.5
 |  | 59 | 1
 |  | 59.4 | 0.3999999999999986
 |  | 59.2 | -0.1999999999999957
 |  | 56.1 | -3.100000000000001
 |  | 57.4 | 1.299999999999997
 |  | 55.1 | -2.299999999999997
 |  | 52.1 | -3
 |  | 51.5 | -0.6000000000000014
 |  | 46.7 | -4.799999999999997
 |  | 45.9 | -0.8000000000000043
 |  | 50.7 | 4.800000000000004
 |  | 47.1 | -3.600000000000001
 |  | 48.1 | 1
 |  | 46.7 | -1.399999999999999
 |  | 45.9 | -0.8000000000000043
 |  | 46.2 | 0.3000000000000043
 |  | 45.5 | -0.7000000000000028
 |  | 45.9 | 0.3999999999999986
 |  | 46.9 | 1
 |  | 49.3 | 2.399999999999999
 |  | 49.1 | -0.1999999999999957
 |  | 53.6 | 4.5
 |  | 49.7 | -3.899999999999999
 |  | 51.6 | 1.899999999999999
 |  | 51.1 | -0.5
 |  | 50.5 | -0.6000000000000014
 |  | 53 | 2.5
 |  | 55.2 | 2.200000000000003
 |  | 53.8 | -1.400000000000006
 |  | 53.1 | -0.6999999999999957
 |  | 53.8 | 0.6999999999999957
 |  | 53.7 | -0.09999999999999432
 |  | 56.1 | 2.399999999999999
 |  | 54.9 | -1.200000000000003
 |  | 57.7 | 2.800000000000004
 |  | 56.3 | -1.400000000000006
 |  | 53.9 | -2.399999999999999
 |  | 56.4 | 2.5
 |  | 55.7 | -0.6999999999999957
 |  | 54.5 | -1.200000000000003
 |  | 53.8 | -0.7000000000000028
 |  | 52.9 | -0.8999999999999986
 |  | 52.9 | 0
 |  | 52.2 | -0.6999999999999957
 |  | 50.9 | -1.300000000000004
 |  | 48.9 | -2
 |  | 49.2 | 0.3000000000000043
 |  | 49.3 | 0.09999999999999432
 |  | 48.7 | -0.5999999999999943
 |  | 48.7 | 0
 |  | 48.2 | -0.5
 |  | 46.8 | -1.400000000000006
 |  | 50.6 | 3.800000000000004
 |  | 51.7 | 1.100000000000001
 |  | 52.4 | 0.6999999999999957
 |  | 52.3 | -0.1000000000000014
 |  | 54.3 | 2
 |  | 55.8 | 1.5
 |  | 53.6 | -2.199999999999996
 |  | 54.8 | 1.199999999999996
 |  | 57 | 2.200000000000003
 |  | 57.2 | 0.2000000000000028
 |  | 58.1 | 0.8999999999999986
 |  | 57.8 | -0.3000000000000043
 |  | 56.7 | -1.099999999999994
 |  | 55.8 | -0.9000000000000057
 |  | 54.9 | -0.8999999999999986
 |  | 54.7 | -0.1999999999999957
 |  | 53.2 | -1.5
 |  | 51.4 | -1.800000000000004
 |  | 52.5 | 1.100000000000001
 |  | 49.9 | -2.600000000000001
 |  | 49.7 | -0.1999999999999957
 |  | 48.7 | -1
 |  | 48.5 | -0.2000000000000028
 |  | 43.9 | -4.600000000000001
 |  | 42.3 | -1.600000000000001
 |  | 42.1 | -0.1999999999999957
 |  | 43.1 | 1
 |  | 42.7 | -0.3999999999999986
 |  | 41.3 | -1.400000000000006
 |  | 43.2 | 1.900000000000006
 |  | 43.5 | 0.2999999999999972
 |  | 46.3 | 2.799999999999997
 |  | 46.2 | -0.09999999999999432
 |  | 40.8 | -5.400000000000006
 |  | 44.1 | 3.300000000000004
 |  | 45.3 | 1.199999999999996
 |  | 47.5 | 2.200000000000003
 |  | 50.7 | 3.200000000000003
 |  | 52.4 | 1.699999999999996
 |  | 52.4 | 0
 |  | 53.1 | 0.7000000000000028
 |  | 53.6 | 0.5
 |  | 50.2 | -3.399999999999999
 |  | 50.3 | 0.09999999999999432
 |  | 50.5 | 0.2000000000000028
 |  | 49 | -1.5
 |  | 48.5 | -0.5
 |  | 51.6 | 3.100000000000001
 |  | 51.3 | -0.3000000000000043
 |  | 48.8 | -2.5
 |  | 46.3 | -2.5
 |  | 46.1 | -0.1999999999999957
 |  | 49 | 2.899999999999999
 |  | 49 | 0
 |  | 51 | 2
 |  | 53.2 | 2.200000000000003
 |  | 52.4 | -0.8000000000000043
 |  | 55.2 | 2.800000000000004
 |  | 58.4 | 3.199999999999996
 |  | 60.1 | 1.700000000000003
 |  | 60.8 | 0.6999999999999957
 |  | 59.9 | -0.8999999999999986
 |  | 60.6 | 0.7000000000000028
 |  | 60.6 | 0
 |  | 61.4 | 0.7999999999999972
 |  | 60.5 | -0.8999999999999986
 |  | 59.9 | -0.6000000000000014
 |  | 58.5 | -1.399999999999999
 |  | 57.4 | -1.100000000000001
 |  | 56.3 | -1.100000000000001
 |  | 56.2 | -0.09999999999999432
 |  | 57.2 | 1
 |  | 56.8 | -0.4000000000000057
 |  | 55.5 | -1.299999999999997
 |  | 55.2 | -0.2999999999999972
 |  | 52.2 | -3
 |  | 50.8 | -1.400000000000006
 |  | 52.4 | 1.600000000000001
 |  | 52.8 | 0.3999999999999986
 |  | 52.4 | -0.3999999999999986
 |  | 56.8 | 4.399999999999999
 |  | 57.2 | 0.4000000000000057
 |  | 56.7 | -0.5
 |  | 55.1 | -1.600000000000001
 |  | 55 | -0.1000000000000014
 |  | 55.8 | 0.7999999999999972
 |  | 54.3 | -1.5
 |  | 55.2 | 0.9000000000000057
 |  | 53.7 | -1.5
 |  | 52 | -1.700000000000003
 |  | 53 | 1
 |  | 53.7 | 0.7000000000000028
 |  | 52.2 | -1.5
 |  | 51.4 | -0.8000000000000043
 |  | 50.3 | -1.100000000000001
 |  | 51.4 | 1.100000000000001
 |  | 49.5 | -1.899999999999999
 |  | 51.9 | 2.399999999999999
 |  | 50.7 | -1.199999999999996
 |  | 52.6 | 1.899999999999999
 |  | 52.5 | -0.1000000000000014
 |  | 52.6 | 0.1000000000000014
 |  | 52.4 | -0.2000000000000028
 |  | 50.9 | -1.5
 |  | 51 | 0.1000000000000014
 |  | 51.1 | 0.1000000000000014
 |  | 50.5 | -0.6000000000000014
 |  | 49 | -1.5
 |  | 50.3 | 1.299999999999997
 |  | 48.3 | -2
 |  | 48.6 | 0.3000000000000043
 |  | 48.6 | 0
 |  | 49.6 | 1
 |  | 50.2 | 0.6000000000000014
 |  | 50 | -0.2000000000000028
 |  | 49.9 | -0.1000000000000014
 |  | 43.5 | -6.399999999999999
 |  | 38.9 | -4.600000000000001
 |  | 36.2 | -2.699999999999996
 |  | 32.4 | -3.800000000000004
 |  | 35.6 | 3.200000000000003
 |  | 35.8 | 0.1999999999999957
 |  | 36.3 | 0.5
 |  | 40.1 | 3.800000000000004
 |  | 42.8 | 2.699999999999996
 |  | 44.8 | 2
 |  | 48.9 | 4.100000000000001
 |  | 52.9 | 4
 |  | 52.6 | -0.2999999999999972
 |  | 55.7 | 3.100000000000001
 |  | 53.6 | -2.100000000000001
 |  | 55.9 | 2.299999999999997
 |  | 58.4 | 2.5
 |  | 56.5 | -1.899999999999999
 |  | 59.6 | 3.100000000000001
 |  | 60.4 | 0.7999999999999972
 |  | 59.7 | -0.6999999999999957
 |  | 56.2 | -3.5
 |  | 55.5 | -0.7000000000000028
 |  | 56.3 | 0.7999999999999972
 |  | 54.4 | -1.899999999999999
 |  | 56.9 | 2.5
 |  | 56.6 | -0.2999999999999972
 |  | 57 | 0.3999999999999986
 |  | 60.8 | 3.799999999999997
 |  | 61.4 | 0.6000000000000014
 |  | 61.2 | -0.1999999999999957
 |  | 60.4 | -0.8000000000000043
 |  | 53.5 | -6.899999999999999
 |  | 55.3 | 1.799999999999997
 |  | 50.9 | -4.399999999999999
 |  | 50.6 | -0.2999999999999972
 |  | 51.6 | 1
 |  | 50.8 | -0.8000000000000043
 |  | 52.7 | 1.900000000000006
 |  | 53.9 | 1.199999999999996
 |  | 54.1 | 0.2000000000000028
 |  | 52.4 | -1.700000000000003
 |  | 53.4 | 1
 |  | 54.8 | 1.399999999999999
 |  | 53.5 | -1.299999999999997
 |  | 49.7 | -3.799999999999997
 |  | 49.8 | 0.09999999999999432
 |  | 49.6 | -0.1999999999999957
 |  | 51.5 | 1.899999999999999
 |  | 51.7 | 0.2000000000000028
 |  | 49.5 | -2.200000000000003
 |  | 50.7 | 1.200000000000003
 |  | 53.1 | 2.399999999999999
 |  | 54.2 | 1.100000000000001
 |  | 51.3 | -2.900000000000006
 |  | 50.7 | -0.5999999999999943
 |  | 49 | -1.700000000000003
 |  | 50.9 | 1.899999999999999
 |  | 55.4 | 4.5
 |  | 55.7 | 0.3000000000000043
 |  | 56.2 | 0.5
 |  | 56.4 | 0.1999999999999957
 |  | 57.3 | 0.8999999999999986
 |  | 57 | -0.2999999999999972
 |  | 51.3 | -5.700000000000003
 |  | 53.2 | 1.900000000000006
 |  | 53.7 | 0.5
 |  | 54.9 | 1.199999999999996
 |  | 55.4 | 0.5
 |  | 55.3 | -0.1000000000000014
 |  | 57.1 | 1.800000000000004
 |  | 59 | 1.899999999999999
 |  | 56.6 | -2.399999999999999
 |  | 59 | 2.399999999999999
 |  | 58.7 | -0.2999999999999972
 |  | 55.5 | -3.200000000000003
 |  | 53.5 | -2
 |  | 52.9 | -0.6000000000000014
 |  | 51.5 | -1.399999999999999
 |  | 51.5 | 0
 |  | 52.8 | 1.299999999999997
 |  | 53.5 | 0.7000000000000028
 |  | 52.7 | -0.7999999999999972
 |  | 51.1 | -1.600000000000001
 |  | 50.2 | -0.8999999999999986
 |  | 50.1 | -0.1000000000000014
 |  | 48.6 | -1.5
 |  | 48.2 | -0.3999999999999986
 |  | 48.2 | 0
 |  | 49.5 | 1.299999999999997
 |  | 51.8 | 2.299999999999997
 |  | 50.8 | -1
 |  | 51.3 | 0.5
 |  | 53.2 | 1.900000000000006
 |  | 52.6 | -0.6000000000000014
 |  | 49.4 | -3.200000000000003
 |  | 51.5 | 2.100000000000001
 |  | 51.9 | 0.3999999999999986
 |  | 53.2 | 1.300000000000004
 |  | 54.7 | 1.5
 |  | 56 | 1.299999999999997
 |  | 57.7 | 1.700000000000003
 |  | 57.2 | -0.5
 |  | 54.8 | -2.400000000000006
 |  | 54.9 | 0.1000000000000014
 |  | 57.8 | 2.899999999999999
 |  | 56.3 | -1.5
 |  | 58.8 | 2.5
 |  | 60.8 | 2
 |  | 58.7 | -2.099999999999994
 |  | 58.2 | -0.5
 |  | 59.7 | 1.5
 |  | 59.1 | -0.6000000000000014
 |  | 60.7 | 1.600000000000001
 |  | 59.3 | -1.400000000000006
 |  | 57.9 | -1.399999999999999
 |  | 58.7 | 0.8000000000000043
 |  | 60 | 1.299999999999997
 |  | 58.4 | -1.600000000000001
 |  | 60.8 | 2.399999999999999
 |  | 59.5 | -1.299999999999997
 |  | 57.5 | -2
 |  | 58.8 | 1.299999999999997
 |  | 54.3 | -4.5
 |  | 56.6 | 2.300000000000004
 |  | 54.2 | -2.399999999999999
 |  | 55.3 | 1.099999999999994
 |  | 52.8 | -2.5
 |  | 52.1 | -0.6999999999999957
 |  | 51.7 | -0.3999999999999986
 |  | 51.2 | -0.5
 |  | 49.1 | -2.100000000000001
 |  | 47.8 | -1.300000000000004
 |  | 48.3 | 0.5
 |  | 48.1 | -0.1999999999999957
 |  | 47.2 | -0.8999999999999986
 |  | 50.9 | 3.699999999999996
 |  | 50.1 | -0.7999999999999972
 |  | 49.1 | -1
 |  | 41.5 | -7.600000000000001
 |  | 43.1 | 1.600000000000001
 |  | 52.6 | 9.5
 |  | 54.2 | 1.600000000000001
 |  | 56 | 1.799999999999997
 |  | 55.4 | -0.6000000000000014
 |  | 59.3 | 3.899999999999999
 |  | 57.5 | -1.799999999999997
 |  | 60.7 | 3.200000000000003
 |  | 58.7 | -2
 |  | 60.8 | 2.099999999999994
 |  | 64.7 | 3.900000000000006
 |  | 60.7 | -4
 |  | 61.2 | 0.5
 |  | 60.6 | -0.6000000000000014
 |  | 59.5 | -1.100000000000001