Spreadsheet: 752523d1634816099-find-lowest-value-in-a-column-between-2-cells-and-calculate-again-for-next-sample-spreadsheetquery3
Sheet: Sheet1

Date | High | Low | Counter | Result
2020-06-08 00:00:00 | 3234.5 | 3175.5
2020-06-09 00:00:00 | 3234.5 | 3128.5
2020-06-10 00:00:00 | 3192.5 | 3110.5
2020-06-11 00:00:00 | 3119.5 | 2923.5
2020-06-12 00:00:00 | 3049.5 | 2929.5
2020-06-15 00:00:00 | 3019.5 | 2886.5
2020-06-16 00:00:00 | 3114.5 | 3022.5
2020-06-17 00:00:00 | 3120.5 | 3051.5
2020-06-18 00:00:00 | 3128.5 | 3044.5
2020-06-19 00:00:00 | 3141.5 | 3067.5
2020-06-22 00:00:00 | 3123.5 | 3042.5
2020-06-23 00:00:00 | 3163.5 | 3059.5
2020-06-24 00:00:00 | 3140.5 | 3023.5
2020-06-25 00:00:00 | 3106.5 | 2991.5
2020-06-26 00:00:00 | 3117.5 | 3035.5
2020-06-29 00:00:00 | 3101.5 | 3017.5
2020-06-30 00:00:00 | 3108.5 | 3056.5
2020-07-01 00:00:00 | 3107.5 | 3027.5
2020-07-02 00:00:00 | 3184.5 | 3072.5
2020-07-03 00:00:00 | 3181.5 | 3128.5
2020-07-06 00:00:00 | 3227.5 | 3165.5
2020-07-07 00:00:00 | 3222.5 | 3150.5
2020-07-08 00:00:00 | 3181.5 | 3131.5
2020-07-09 00:00:00 | 3185.5 | 3103.5
2020-07-10 00:00:00 | 3175.5 | 3089.5
2020-07-13 00:00:00 | 3211.5 | 3142.5
2020-07-14 00:00:00 | 3200.5 | 3133.5
2020-07-15 00:00:00 | 3257.5 | 3196.5
2020-07-16 00:00:00 | 3235.5 | 3198.5
2020-07-17 00:00:00 | 3240.5 | 3210.5
2020-07-20 00:00:00 | 3256.5 | 3190.5
2020-07-21 00:00:00 | 3311.5 | 3239.5
2020-07-22 00:00:00 | 3268.5 | 3219.5
2020-07-23 00:00:00 | 3261.5 | 3193.5
2020-07-24 00:00:00 | 3216.5 | 3153.5
2020-07-27 00:00:00 | 3184.5 | 3150.5
2020-07-28 00:00:00 | 3190.5 | 3139.5
2020-07-29 00:00:00 | 3177.5 | 3141.5
2020-07-30 00:00:00 | 3175.5 | 3033.5
2020-07-31 00:00:00 | 3107.5 | 3005.5
2020-08-03 00:00:00 | 3124.5 | 3024.5
2020-08-04 00:00:00 | 3140.5 | 3089.5
2020-08-05 00:00:00 | 3154.5 | 3106.5
2020-08-06 00:00:00 | 3148.5 | 3083.5
2020-08-07 00:00:00 | 3124.5 | 3080.5
2020-08-10 00:00:00 | 3139.5 | 3099.5
2020-08-11 00:00:00 | 3212.5 | 3132.5
2020-08-12 00:00:00 | 3240.5 | 3161.5
2020-08-13 00:00:00 | 3231.5 | 3186.5
2020-08-14 00:00:00 | 3208.5 | 3136.5
2020-08-17 00:00:00 | 3182.5 | 3147.5
2020-08-18 00:00:00 | 3196.5 | 3137.5
2020-08-19 00:00:00 | 3183.5 | 3136.5
2020-08-20 00:00:00 | 3159.5 | 3118.5
2020-08-21 00:00:00 | 3161.5 | 3081.5
2020-08-24 00:00:00 | 3201.5 | 3124.5
2020-08-25 00:00:00 | 3236.5 | 3178.5
2020-08-26 00:00:00 | 3230.5 | 3176.5
2020-08-27 00:00:00 | 3227.5 | 3175.5
2020-08-28 00:00:00 | 3216.5 | 3159.5
2020-08-31 00:00:00 | 3215.5 | 3125.5
2020-09-01 00:00:00 | 3176.5 | 3107.5
2020-09-02 00:00:00 | 3230.5 | 3146.5
2020-09-03 00:00:00 | 3261.5 | 3132.5
2020-09-04 00:00:00 | 3194.5 | 3098.5
2020-09-07 00:00:00 | 3186.5 | 3128.5
2020-09-08 00:00:00 | 3193.5 | 3105.5
2020-09-09 00:00:00 | 3212.5 | 3107.5
2020-09-10 00:00:00 | 3209.5 | 3147.5
2020-09-11 00:00:00 | 3195.5 | 3157.5
2020-09-14 00:00:00 | 3214.5 | 3169.5
2020-09-15 00:00:00 | 3211.5 | 3166.5
2020-09-16 00:00:00 | 3215.5 | 3176.5
2020-09-17 00:00:00 | 3192.5 | 3150.5
2020-09-18 00:00:00 | 3191.5 | 3127.5
2020-09-21 00:00:00 | 3153.5 | 3013.5
2020-09-22 00:00:00 | 3063.5 | 3019.5
2020-09-23 00:00:00 | 3087.5 | 3014.5
2020-09-24 00:00:00 | 3047.5 | 2993.5
2020-09-25 00:00:00 | 3050.5 | 2962.5
2020-09-28 00:00:00 | 3097.5 | 3029.5
2020-09-29 00:00:00 | 3109.5 | 3063.5
2020-09-30 00:00:00 | 3099.5 | 3041.5
2020-10-01 00:00:00 | 3092.5 | 3044.5
2020-10-02 00:00:00 | 3071.5 | 3012.5
2020-10-05 00:00:00 | 3104.5 | 3065.5
2020-10-06 00:00:00 | 3119.5 | 3068.5
2020-10-07 00:00:00 | 3113.5 | 3073.5
2020-10-08 00:00:00 | 3139.5 | 3101.5
2020-10-09 00:00:00 | 3151.5 | 3121.5
2020-10-12 00:00:00 | 3177.5 | 3134.5
2020-10-13 00:00:00 | 3173.5 | 3132.5
2020-10-14 00:00:00 | 3156.5 | 3121.5
2020-10-15 00:00:00 | 3131.5 | 3042.5
2020-10-16 00:00:00 | 3128.5 | 3067.5
2020-10-19 00:00:00 | 3152.5 | 3073.5
2020-10-20 00:00:00 | 3120.5 | 3084.5
2020-10-21 00:00:00 | 3119.5 | 3040.5
2020-10-22 00:00:00 | 3055.5 | 3001.5
2020-10-23 00:00:00 | 3087.5 | 3029.5
2020-10-26 00:00:00 | 3056.5 | 2950.5
2020-10-27 00:00:00 | 2990.5 | 2906.5
2020-10-28 00:00:00 | 2908.5 | 2800.5
2020-10-29 00:00:00 | 2858.5 | 2790.5
2020-10-30 00:00:00 | 2852.5 | 2763.5
2020-11-02 00:00:00 | 2905.5 | 2823.5
2020-11-03 00:00:00 | 2994.5 | 2906.5
2020-11-04 00:00:00 | 3046.5 | 2885.5
2020-11-05 00:00:00 | 3095.5 | 3013.5
2020-11-06 00:00:00 | 3097.5 | 3039.5
2020-11-09 00:00:00 | 3317.5 | 3117.5
2020-11-10 00:00:00 | 3334.5 | 3221.5
2020-11-11 00:00:00 | 3347.5 | 3297.5
2020-11-12 00:00:00 | 3333.5 | 3269.5
2020-11-13 00:00:00 | 3329.5 | 3268.5
2020-11-16 00:00:00 | 3371.5 | 3312.5
2020-11-17 00:00:00 | 3353.5 | 3314.5
2020-11-18 00:00:00 | 3363.5 | 3324.5
2020-11-19 00:00:00 | 3342.5 | 3312.5
2020-11-20 00:00:00 | 3355.5 | 3314.5
2020-11-23 00:00:00 | 3380.5 | 3334.5
2020-11-24 00:00:00 | 3393.5 | 3360.5
2020-11-25 00:00:00 | 3405.5 | 3366.5
2020-11-26 00:00:00 | 3400.5 | 3372.5
2020-11-27 00:00:00 | 3412.5 | 3370.5
2020-11-30 00:00:00 | 3412.5 | 3350.5
2020-12-01 00:00:00 | 3407.5 | 3373.5
2020-12-02 00:00:00 | 3398.5 | 3375.5
2020-12-03 00:00:00 | 3401.5 | 3370.5
2020-12-04 00:00:00 | 3415.5 | 3375.5
2020-12-07 00:00:00 | 3414.5 | 3371.5
2020-12-08 00:00:00 | 3411.5 | 3376.5
2020-12-09 00:00:00 | 3433.5 | 3389.5
2020-12-10 00:00:00 | 3416.5 | 3372.5
2020-12-11 00:00:00 | 3398.5 | 3334.5
2020-12-14 00:00:00 | 3407.5 | 3367.5
2020-12-15 00:00:00 | 3415.5 | 3367.5
2020-12-16 00:00:00 | 3436.5 | 3398.5
2020-12-17 00:00:00 | 3451.5 | 3421.5
2020-12-18 00:00:00 | 3463.5 | 3407.5
2020-12-21 00:00:00 | 3377.5 | 3272.5
2020-12-22 00:00:00 | 3378.5 | 3323.5
2020-12-23 00:00:00 | 3424.5 | 3350.5
2020-12-28 00:00:00 | 3462.5 | 3426.5
2020-12-29 00:00:00 | 3481.5 | 3436.5
2020-12-30 00:00:00 | 3468.5 | 3428.5
2021-01-04 00:00:00 | 3490.5 | 3408.5
2021-01-05 00:00:00 | 3454.5 | 3402.5
2021-01-06 00:00:00 | 3505.5 | 3419.5
2021-01-07 00:00:00 | 3516.5 | 3483.5
2021-01-08 00:00:00 | 3539.5 | 3507.5
2021-01-11 00:00:00 | 3524.5 | 3473.5
2021-01-12 00:00:00 | 3516.5 | 3470.5
2021-01-13 00:00:00 | 3505.5 | 3478.5
2021-01-14 00:00:00 | 3528.5 | 3500.5
2021-01-15 00:00:00 | 3517.5 | 3452.5
2021-01-18 00:00:00 | 3497.5 | 3455.5
2021-01-19 00:00:00 | 3510.5 | 3473.5
2021-01-20 00:00:00 | 3518.5 | 3476.5
2021-01-21 00:00:00 | 3533.5 | 3491.5
2021-01-22 00:00:00 | 3504.5 | 3453.5
2021-01-25 00:00:00 | 3508.5 | 3423.5
2021-01-26 00:00:00 | 3492.5 | 3415.5
2021-01-27 00:00:00 | 3483.5 | 3385.5
2021-01-28 00:00:00 | 3458.5 | 3357.5
2021-01-29 00:00:00 | 3435.5 | 3346.5
2021-02-01 00:00:00 | 3432.5 | 3362.5
2021-02-02 00:00:00 | 3491.5 | 3427.5
2021-02-03 00:00:00 | 3521.5 | 3482.5
2021-02-04 00:00:00 | 3533.5 | 3483.5
2021-02-05 00:00:00 | 3556.5 | 3528.5
2021-02-08 00:00:00 | 3575.5 | 3547.5
2021-02-09 00:00:00 | 3563.5 | 3536.5
2021-02-10 00:00:00 | 3569.5 | 3513.5
2021-02-11 00:00:00 | 3561.5 | 3525.5
2021-02-12 00:00:00 | 3590.5 | 3535.5
2021-02-15 00:00:00 | 3630.5 | 3596.5
2021-02-16 00:00:00 | 3634.5 | 3604.5
2021-02-17 00:00:00 | 3615.5 | 3582.5
2021-02-18 00:00:00 | 3605.5 | 3560.5
2021-02-19 00:00:00 | 3609.5 | 3561.5
2021-02-22 00:00:00 | 3612.5 | 3549.5
2021-02-23 00:00:00 | 3602.5 | 3532.5
2021-02-24 00:00:00 | 3608.5 | 3555.5
2021-02-25 00:00:00 | 3620.5 | 3529.5
2021-02-26 00:00:00 | 3566.5 | 3509.5
2021-03-01 00:00:00 | 3606.5 | 3544.5
2021-03-02 00:00:00 | 3619.5 | 3578.5
2021-03-03 00:00:00 | 3633.5 | 3577.5
2021-03-04 00:00:00 | 3609.5 | 3548.5
2021-03-05 00:00:00 | 3606.5 | 3536.5
2021-03-08 00:00:00 | 3667.5 | 3570.5
2021-03-09 00:00:00 | 3688.5 | 3639.5
2021-03-10 00:00:00 | 3718.5 | 3664.5
2021-03-11 00:00:00 | 3740.5 | 3710.5
2021-03-12 00:00:00 | 3743.5 | 3709.5
2021-03-15 00:00:00 | 3749.5 | 3709.5
2021-03-16 00:00:00 | 3750.5 | 3728.5
2021-03-17 00:00:00 | 3760.5 | 3730.5
2021-03-18 00:00:00 | 3773.5 | 3723.5
2021-03-19 00:00:00 | 3754.5 | 3709.5
2021-03-22 00:00:00 | 3734.5 | 3702.5
2021-03-23 00:00:00 | 3734.5 | 3694.5
2021-03-24 00:00:00 | 3727.5 | 3693.5
2021-03-25 00:00:00 | 3752.5 | 3679.5
2021-03-26 00:00:00 | 3790.5 | 3740.5
2021-03-29 00:00:00 | 3798.5 | 3756.5
2021-03-30 00:00:00 | 3826.5 | 3787.5
2021-03-31 00:00:00 | 3830.5 | 3807.5
2021-04-01 00:00:00 | 3873.5 | 3819.5
2021-04-06 00:00:00 | 3894.5 | 3856.5
2021-04-07 00:00:00 | 3873.5 | 3852.5
2021-04-08 00:00:00 | 3882.5 | 3862.5
2021-04-09 00:00:00 | 3891.5 | 3870.5
2021-04-12 00:00:00 | 3885.5 | 3859.5
2021-04-13 00:00:00 | 3882.5 | 3853.5
2021-04-14 00:00:00 | 3885.5 | 3865.5
2021-04-15 00:00:00 | 3902.5 | 3870.5
2021-04-16 00:00:00 | 3952.5 | 3892.5
2021-04-19 00:00:00 | 3949.5 | 3913.5
2021-04-20 00:00:00 | 3929.5 | 3841.5
2021-04-21 00:00:00 | 3904.5 | 3843.5
2021-04-22 00:00:00 | 3926.5 | 3894.5
2021-04-23 00:00:00 | 3926.5 | 3886.5
2021-04-26 00:00:00 | 3932.5 | 3909.5
2021-04-27 00:00:00 | 3932.5 | 3907.5
2021-04-28 00:00:00 | 3937.5 | 3914.5
2021-04-29 00:00:00 | 3945.5 | 3894.5
2021-04-30 00:00:00 | 3921.5 | 3874.5
2021-05-03 00:00:00 | 3928.5 | 3880.5
2021-05-04 00:00:00 | 3937.5 | 3834.5
2021-05-05 00:00:00 | 3930.5 | 3859.5
2021-05-06 00:00:00 | 3951.5 | 3901.5
2021-05-07 00:00:00 | 3973.5 | 3936.5
2021-05-10 00:00:00 | 3988.5 | 3934.5
2021-05-11 00:00:00 | 3936.5 | 3853.5
2021-05-12 00:00:00 | 3902.5 | 3845.5
2021-05-13 00:00:00 | 3913.5 | 3796.5
2021-05-14 00:00:00 | 3982.5 | 3902.5
2021-05-17 00:00:00 | 3977.5 | 3936.5
2021-05-18 00:00:00 | 3986.5 | 3930.5
2021-05-19 00:00:00 | 3935.5 | 3834.5
2021-05-20 00:00:00 | 3955.5 | 3879.5
2021-05-21 00:00:00 | 3979.5 | 3943.5
2021-05-24 00:00:00 | 4003.5 | 3970.5
2021-05-25 00:00:00 | 4011.5 | 3983.5
2021-05-26 00:00:00 | 4005.5 | 3970.5
2021-05-27 00:00:00 | 4006.5 | 3968.5
2021-05-28 00:00:00 | 4026.5 | 3997.5
2021-05-31 00:00:00 | 4025.5 | 3984.5
2021-06-01 00:00:00 | 4052.5 | 3989.5
2021-06-02 00:00:00 | 4042.5 | 4013.5
2021-06-03 00:00:00 | 4046.5 | 4002.5
2021-06-04 00:00:00 | 4050.5 | 4018.5
2021-06-07 00:00:00 | 4058.5 | 4020.5
2021-06-08 00:00:00 | 4068.5 | 4043.5
2021-06-09 00:00:00 | 4061.5 | 4028.5
2021-06-10 00:00:00 | 4061.5 | 4031.5
2021-06-11 00:00:00 | 4094.5 | 4049.5
2021-06-14 00:00:00 | 4107.5 | 4079.5
2021-06-15 00:00:00 | 4110.5 | 4092.5
2021-06-16 00:00:00 | 4111.5 | 4088.5
2021-06-17 00:00:00 | 4122.5 | 4075.5
2021-06-18 00:00:00 | 4117.5 | 4024.5
2021-06-21 00:00:00 | 4076.5 | 3981.5
2021-06-22 00:00:00 | 4080.5 | 4042
2021-06-23 00:00:00 | 4085.5 | 4024
2021-06-24 00:00:00 | 4082.5 | 4035.5
2021-06-25 00:00:00 | 4087.5 | 4058.5
2021-06-28 00:00:00 | 4080 | 4040
2021-06-29 00:00:00 | 4078.5 | 4041.5
2021-06-30 00:00:00 | 4068 | 4000
2021-07-01 00:00:00 | 4068 | 4003.5
2021-07-02 00:00:00 | 4055.5 | 4029.5
2021-07-05 00:00:00 | 4050 | 4010.5
2021-07-06 00:00:00 | 4050 | 3991
2021-07-07 00:00:00 | 4041 | 3993.5
2021-07-08 00:00:00 | 4040 | 3918
2021-07-09 00:00:00 | 4029.5 | 3929
2021-07-12 00:00:00 | 4058.5 | 4001
2021-07-13 00:00:00 | 4062 | 4039.5
2021-07-14 00:00:00 | 4061.5 | 4030.5
2021-07-15 00:00:00 | 4050.5 | 3997.5
2021-07-16 00:00:00 | 4029.5 | 3969.5
2021-07-19 00:00:00 | 3973 | 3861.5
2021-07-20 00:00:00 | 3938 | 3878.5
2021-07-21 00:00:00 | 4003 | 3910.5
2021-07-22 00:00:00 | 4038 | 3996
2021-07-23 00:00:00 | 4078 | 4025
2021-07-26 00:00:00 | 4067 | 4032
2021-07-27 00:00:00 | 4066.5 | 4014
2021-07-28 00:00:00 | 4066 | 4019.5
2021-07-29 00:00:00 | 4090 | 4046.5
2021-07-30 00:00:00 | 4074.5 | 4038.5
2021-08-02 00:00:00 | 4097 | 4056.5
2021-08-03 00:00:00 | 4091.5 | 4062.5
2021-08-04 00:00:00 | 4111.5 | 4079.5
2021-08-05 00:00:00 | 4127.5 | 4098.5
2021-08-06 00:00:00 | 4146 | 4113
2021-08-09 00:00:00 | 4148.5 | 4123
2021-08-10 00:00:00 | 4158.5 | 4135.5
2021-08-11 00:00:00 | 4181.5 | 4146.5
2021-08-12 00:00:00 | 4196 | 4163
2021-08-13 00:00:00 | 4205 | 4185
2021-08-16 00:00:00 | 4182.5 | 4151.5
2021-08-17 00:00:00 | 4175.5 | 4134
2021-08-18 00:00:00 | 4172 | 4132
2021-08-19 00:00:00 | 4136 | 4044.5
2021-08-20 00:00:00 | 4120 | 4068
2021-08-23 00:00:00 | 4148.5 | 4119
2021-08-24 00:00:00 | 4163 | 4126
2021-08-25 00:00:00 | 4152 | 4135
2021-08-26 00:00:00 | 4140.5 | 4105
2021-08-27 00:00:00 | 4163 | 4117.5
2021-08-30 00:00:00 | 4167.5 | 4147
2021-08-31 00:00:00 | 4186.5 | 4138.5
2021-09-01 00:00:00 | 4216 | 4162.5
2021-09-02 00:00:00 | 4204 | 4179
2021-09-03 00:00:00 | 4203 | 4146.5
2021-09-06 00:00:00 | 4218.5 | 4151.5
2021-09-07 00:00:00 | 4210.5 | 4179
2021-09-08 00:00:00 | 4189 | 4124.5
2021-09-09 00:00:00 | 4161 | 4099
2021-09-10 00:00:00 | 4171.5 | 4119.5
2021-09-13 00:00:00 | 4177.5 | 4121.5
2021-09-14 00:00:00 | 4169.5 | 4129.5
2021-09-15 00:00:00 | 4165 | 4109.5
2021-09-16 00:00:00 | 4167 | 4126
2021-09-17 00:00:00 | 4184 | 4082
2021-09-20 00:00:00 | 4102.5 | 3974
2021-09-21 00:00:00 | 4085.5 | 4014
2021-09-22 00:00:00 | 4145.5 | 4047
2021-09-23 00:00:00 | 4185.5 | 4137.5
2021-09-24 00:00:00 | 4200.5 | 4128.5
2021-09-27 00:00:00 | 4180 | 4137.5
2021-09-28 00:00:00 | 4161.5 | 4030.5
2021-09-29 00:00:00 | 4091 | 4036.5
2021-09-30 00:00:00 | 4100 | 4010.5
2021-10-01 00:00:00 | 4049.5 | 3961
2021-10-04 00:00:00 | 4047.5 | 3976
2021-10-05 00:00:00 | 4053.5 | 3968
2021-10-06 00:00:00 | 4046 | 3949.5
2021-10-07 00:00:00 | 4085 | 4029.5
2021-10-08 00:00:00 | 4089 | 4051.5
2021-10-11 00:00:00 | 4070.5 | 4029.5
2021-10-12 00:00:00 | 4052.5 | 4004
2021-10-13 00:00:00 | 4085.5 | 4026
2021-10-14 00:00:00 | 4146 | 4085.5
2021-10-15 00:00:00 | 4175 | 4138
2021-10-18 00:00:00 | 4174 | 4119