highs and lows

[dmheller]

I have seen several post about this in the past via search but i was hoping there was a better way to find the highs and lows than using 5 helper columns. I am wanting to find the low and high each time along with the date and time it happened.
I was hoping to do this with a Let formula. Please let me know if you can help.
thanks

8/6/2024 16:48	27.07074
8/6/2024 16:48	27.06866
8/6/2024 16:48	27.05708
8/6/2024 16:49	27.05482
8/6/2024 16:49	27.04707
8/6/2024 16:49	27.05209
8/6/2024 16:50	27.05242
8/6/2024 16:50	27.05677
8/6/2024 16:50	27.05141
8/6/2024 16:51	27.05256
8/6/2024 16:51	27.04018
8/6/2024 16:51	27.05569
8/6/2024 16:52	27.04778
8/6/2024 16:52	27.04755
8/6/2024 16:52	27.03412
8/6/2024 16:53	27.04916
8/6/2024 16:53	27.03556
8/6/2024 16:53	27.03226
8/6/2024 16:54	27.03216
8/6/2024 16:54	27.02731
8/6/2024 16:54	27.03384
8/6/2024 16:55	27.04128
8/6/2024 16:55	27.03334
8/6/2024 16:55	27.03842
8/6/2024 16:56	27.03031
8/6/2024 16:56	27.03842
8/6/2024 16:56	27.02583
8/6/2024 16:57	27.01765
8/6/2024 16:57	27.02364
8/6/2024 16:57	27.01586
8/6/2024 16:58	27.0123
8/6/2024 16:58	27.01624
8/6/2024 16:58	27.00294
8/6/2024 16:59	27.01186
8/6/2024 16:59	27.00903
8/6/2024 16:59	27.00826
8/6/2024 17:00	27.01701
8/6/2024 17:00	27.00893
8/6/2024 17:00	27.0063
8/6/2024 17:01	27.00951
8/6/2024 17:01	27.00513
8/6/2024 17:01	27.01879
8/6/2024 17:02	26.98425
8/6/2024 17:02	26.99146
8/6/2024 17:02	26.99664
8/6/2024 17:03	27.00307
8/6/2024 17:03	26.99914
8/6/2024 17:03	26.99822
8/6/2024 17:04	26.99099
8/6/2024 17:04	26.9922
8/6/2024 17:04	26.98823
8/6/2024 17:05	26.99075
8/6/2024 17:05	26.98715
8/6/2024 17:05	26.98462
8/6/2024 17:06	26.98237
8/6/2024 17:06	26.97924
8/6/2024 17:06	26.98025
8/6/2024 17:07	26.97927
8/6/2024 17:07	26.97243
8/6/2024 17:07	26.97301
8/6/2024 17:08	26.97977
8/6/2024 17:08	26.96856
8/6/2024 17:08	26.97301
8/6/2024 17:09	26.97462
8/6/2024 17:09	26.97453
8/6/2024 17:09	26.96173
8/6/2024 17:10	26.97075
8/6/2024 17:10	26.97365
8/6/2024 17:10	26.95621
8/6/2024 17:11	26.96102
8/6/2024 17:11	26.94968
8/6/2024 17:11	26.95513
8/6/2024 17:12	26.96452
8/6/2024 17:12	26.95695
8/6/2024 17:12	26.94933
8/6/2024 17:13	26.95736
8/6/2024 17:13	26.93927
8/6/2024 17:13	26.94211
8/6/2024 17:14	26.93217
8/6/2024 17:14	26.93042
8/6/2024 17:14	26.92783
8/6/2024 17:15	26.93681
8/6/2024 17:15	26.94119
8/6/2024 17:15	26.9391
8/6/2024 17:16	26.93797
8/6/2024 17:16	26.92322
8/6/2024 17:16	26.94132
8/6/2024 17:17	26.92379
8/6/2024 17:17	26.91824
8/6/2024 17:17	26.91672
8/6/2024 17:18	26.91746
8/6/2024 17:18	26.91018
8/6/2024 17:18	26.93422
8/6/2024 17:19	26.90039
8/6/2024 17:19	26.8885
8/6/2024 17:19	26.89312
8/6/2024 17:20	26.89166
8/6/2024 17:20	26.90897
8/6/2024 17:20	26.90186
8/6/2024 17:21	26.89359
8/6/2024 17:21	26.87204
8/6/2024 17:21	26.85447
8/6/2024 17:22	26.88244
8/6/2024 17:22	26.89258
8/6/2024 17:22	26.88705
8/6/2024 17:23	26.87978
8/6/2024 17:23	26.87197
8/6/2024 17:23	26.88089
8/6/2024 17:24	26.88477
8/6/2024 17:24	26.86322
8/6/2024 17:24	26.87339
8/6/2024 17:25	26.85063
8/6/2024 17:25	26.86777
8/6/2024 17:25	26.84525
8/6/2024 17:26	26.83463
8/6/2024 17:26	26.84494
8/6/2024 17:26	26.86107
8/6/2024 17:27	26.83878
8/6/2024 17:27	26.86877
8/6/2024 17:27	26.84154
8/6/2024 17:28	26.82733
8/6/2024 17:28	26.8185
8/6/2024 17:28	26.86318
8/6/2024 17:29	26.81187
8/6/2024 17:29	26.81454
8/6/2024 17:29	26.80228
8/6/2024 17:30	26.79619
8/6/2024 17:30	26.79774
8/6/2024 17:30	26.7904
8/6/2024 17:31	26.80222
8/6/2024 17:31	26.81026
8/6/2024 17:31	26.80151
8/6/2024 17:32	26.82696
8/6/2024 17:32	26.7869
8/6/2024 17:32	26.79548
8/6/2024 17:33	26.79192
8/6/2024 17:33	26.79572
8/6/2024 17:33	26.75124
8/6/2024 17:34	26.76902
8/6/2024 17:34	26.81282
8/6/2024 17:34	26.77636
8/6/2024 17:35	26.77659
8/6/2024 17:35	26.77602
8/6/2024 17:35	26.76505
8/6/2024 17:36	26.75979
8/6/2024 17:36	26.75273
8/6/2024 17:36	26.76525
8/6/2024 17:37	26.7672
8/6/2024 17:37	26.75643
8/6/2024 17:37	26.76798
8/6/2024 17:38	26.75942
8/6/2024 17:38	26.76562
8/6/2024 17:38	26.76694
8/6/2024 17:39	26.75791
8/6/2024 17:39	26.75781
8/6/2024 17:39	26.75377
8/6/2024 17:40	26.76161
8/6/2024 17:40	26.76094
8/6/2024 17:40	26.75343
8/6/2024 17:41	26.75084
8/6/2024 17:41	26.75508
8/6/2024 17:41	26.74306
8/6/2024 17:42	26.75758
8/6/2024 17:42	26.75741
8/6/2024 17:42	26.75273
8/6/2024 17:43	26.7568
8/6/2024 17:43	26.75239
8/6/2024 17:43	26.74989
8/6/2024 17:44	26.75448
8/6/2024 17:44	26.74061
8/6/2024 17:44	26.74905
8/6/2024 17:45	26.75475
8/6/2024 17:45	26.74969
8/6/2024 17:45	26.7476
8/6/2024 17:46	26.7507
8/6/2024 17:46	26.75222
8/6/2024 17:46	26.77323
8/6/2024 17:47	26.7402
8/6/2024 17:47	26.74505
8/6/2024 17:47	26.74535
8/6/2024 17:48	26.74538
8/6/2024 17:48	26.74027
8/6/2024 17:48	26.74084
8/6/2024 17:49	26.74653
8/6/2024 17:49	26.74657
8/6/2024 17:49	26.74229
8/6/2024 17:50	26.73653
8/6/2024 17:50	26.73727
8/6/2024 17:50	26.74394
8/6/2024 17:51	26.72997
8/6/2024 17:51	26.73566
8/6/2024 17:51	26.73061
8/6/2024 17:52	26.74279
8/6/2024 17:52	26.73441
8/6/2024 17:52	26.73791
8/6/2024 17:53	26.72744
8/6/2024 17:53	26.73317
8/6/2024 17:53	26.73707
8/6/2024 17:54	26.7298
8/6/2024 17:54	26.73037
8/6/2024 17:54	26.73118
8/6/2024 17:55	26.73044
8/6/2024 17:55	26.72936
8/6/2024 17:55	26.7374
8/6/2024 17:56	26.72646
8/6/2024 17:56	26.7302
8/6/2024 17:56	26.72993
8/6/2024 17:57	26.73535
8/6/2024 17:57	26.73731
8/6/2024 17:57	26.72765
8/6/2024 17:58	26.72542
8/6/2024 17:58	26.72832
8/6/2024 17:58	26.72727
8/6/2024 17:59	26.72835
8/6/2024 17:59	26.7274
8/6/2024 17:59	26.7295
8/6/2024 18:00	26.73566
8/6/2024 18:00	26.72289
8/6/2024 18:00	26.7234
8/6/2024 18:01	26.71913
8/6/2024 18:01	26.71973
8/6/2024 18:01	26.72212
8/6/2024 18:02	26.71333
8/6/2024 18:02	26.72515
8/6/2024 18:02	26.71559
8/6/2024 18:03	26.71633
8/6/2024 18:03	26.7196
8/6/2024 18:03	26.72195
8/6/2024 18:04	26.71202
8/6/2024 18:04	26.71502
8/6/2024 18:04	26.70943
8/6/2024 18:05	26.71674
8/6/2024 18:05	26.6962
8/6/2024 18:05	26.70438
8/6/2024 18:06	26.71192
8/6/2024 18:06	26.70831
8/6/2024 18:06	26.71054
8/6/2024 18:07	26.70698
8/6/2024 18:07	26.70172
8/6/2024 18:07	26.71011
8/6/2024 18:08	26.69762
8/6/2024 18:08	26.69923
8/6/2024 18:08	26.69943
8/6/2024 18:09	26.69798
8/6/2024 18:09	26.70158
8/6/2024 18:09	26.69822
8/6/2024 18:10	26.70795
8/6/2024 18:10	26.70007
8/6/2024 18:10	26.70455
8/6/2024 18:11	26.69495
8/6/2024 18:11	26.69438
8/6/2024 18:11	26.69088
8/6/2024 18:12	26.68643
8/6/2024 18:12	26.69559
8/6/2024 18:12	26.69018
8/6/2024 18:13	26.69624
8/6/2024 18:13	26.69415
8/6/2024 18:13	26.68869
8/6/2024 18:14	26.68771
8/6/2024 18:14	26.67846
8/6/2024 18:14	26.66209
8/6/2024 18:15	26.67209
8/6/2024 18:15	26.66714
8/6/2024 18:15	26.67519
8/6/2024 18:16	26.67687
8/6/2024 18:16	26.67634
8/6/2024 18:16	26.67643
8/6/2024 18:17	26.65993
8/6/2024 18:17	26.6691
8/6/2024 18:17	26.65765
8/6/2024 18:18	26.65604
8/6/2024 18:18	26.64072
8/6/2024 18:18	26.64775
8/6/2024 18:19	26.64594
8/6/2024 18:19	26.69745
8/6/2024 18:19	26.64957
8/6/2024 18:20	26.71468
8/6/2024 18:20	26.82372
8/6/2024 18:20	27.02229
8/6/2024 18:21	27.16403
8/6/2024 18:21	27.42926
8/6/2024 18:21	27.6731
8/6/2024 18:22	27.92036
8/6/2024 18:22	28.19734
8/6/2024 18:22	28.40927
8/6/2024 18:23	28.6879
8/6/2024 18:23	28.92441
8/6/2024 18:23	29.20091
8/6/2024 18:24	29.43621
8/6/2024 18:24	29.67148
8/6/2024 18:24	29.93745
8/6/2024 18:25	30.16749
8/6/2024 18:25	30.47006
8/6/2024 18:25	30.71509
8/6/2024 18:26	30.95045
8/6/2024 18:26	31.19939
8/6/2024 18:26	31.41664
8/6/2024 18:27	31.68543
8/6/2024 18:27	31.81676
8/6/2024 18:27	32.0792
8/6/2024 18:28	32.33392
8/6/2024 18:28	32.66716
8/6/2024 18:28	32.83135
8/6/2024 18:29	33.06894
8/6/2024 18:29	33.31689
8/6/2024 18:29	33.57963
8/6/2024 18:30	33.81015
8/6/2024 18:30	34.06727
8/6/2024 18:30	34.28139
8/6/2024 18:31	34.51756
8/6/2024 18:31	34.80292
8/6/2024 18:31	34.9929
8/6/2024 18:32	35.32755
8/6/2024 18:32	35.52895
8/6/2024 18:32	35.73441
8/6/2024 18:33	35.94854
8/6/2024 18:33	36.14371
8/6/2024 18:33	36.41227
8/6/2024 18:34	36.64312
8/6/2024 18:34	36.91424
8/6/2024 18:34	37.15075
8/6/2024 18:35	37.4385
8/6/2024 18:35	37.66336
8/6/2024 18:35	37.77308
8/6/2024 18:36	38.01548
8/6/2024 18:36	38.32512
8/6/2024 18:36	38.53843
8/6/2024 18:37	38.7571
8/6/2024 18:37	38.98257
8/6/2024 18:37	39.22752
8/6/2024 18:38	39.41626
8/6/2024 18:38	39.74253
8/6/2024 18:38	39.89881
8/6/2024 18:39	40.14606
8/6/2024 18:39	40.42146
8/6/2024 18:39	40.59309
8/6/2024 18:40	40.83576
8/6/2024 18:40	41.05278
8/6/2024 18:40	41.29491
8/6/2024 18:41	41.43564
8/6/2024 18:41	41.75914
8/6/2024 18:41	41.90863
8/6/2024 18:42	42.222
8/6/2024 18:42	42.39444
8/6/2024 18:42	42.67801
8/6/2024 18:43	42.87924
8/6/2024 18:43	43.08495
8/6/2024 18:43	43.34388
8/6/2024 18:44	43.66813
8/6/2024 18:44	43.82562
8/6/2024 18:44	44.063
8/6/2024 18:45	44.40237
8/6/2024 18:45	44.50542
8/6/2024 18:45	44.73594
8/6/2024 18:46	44.90734
8/6/2024 18:46	45.23108
8/6/2024 18:46	45.38046
8/6/2024 18:47	45.67831
8/6/2024 18:47	45.86297
8/6/2024 18:47	46.05777
8/6/2024 18:48	46.37185
8/6/2024 18:48	46.4878
8/6/2024 18:48	46.78945
8/6/2024 18:49	46.99691
8/6/2024 18:49	47.20433
8/6/2024 18:49	47.40673
8/6/2024 18:50	47.72802
8/6/2024 18:50	47.86892
8/6/2024 18:50	48.1743
8/6/2024 18:51	48.3956
8/6/2024 18:51	48.61578
8/6/2024 18:51	48.82296
8/6/2024 18:52	49.10432
8/6/2024 18:52	49.30713
8/6/2024 18:52	49.49462
8/6/2024 18:53	49.76668
8/6/2024 18:53	50.03215
8/6/2024 18:53	50.19361
8/6/2024 18:54	50.39905
8/6/2024 18:54	50.63707
8/6/2024 18:54	50.88271
8/6/2024 18:55	51.16009
8/6/2024 18:55	51.37909
8/6/2024 18:55	51.50403
8/6/2024 18:56	51.38902
8/6/2024 18:56	51.42255
8/6/2024 18:56	51.41145
8/6/2024 18:57	51.39239
8/6/2024 18:57	51.46023
8/6/2024 18:57	51.43363
8/6/2024 18:58	51.38896
8/6/2024 18:58	51.40582
8/6/2024 18:58	51.39619
8/6/2024 18:59	51.43363
8/6/2024 18:59	51.38606
8/6/2024 18:59	51.44804
8/6/2024 19:00	51.44134
8/6/2024 19:00	51.39306
8/6/2024 19:00	51.42117
8/6/2024 19:01	51.41363
8/6/2024 19:01	51.41209
8/6/2024 19:01	51.3966
8/6/2024 19:02	51.3693
8/6/2024 19:02	51.39865
8/6/2024 19:02	51.37159
8/6/2024 19:03	51.43161
8/6/2024 19:03	51.36792
8/6/2024 19:03	51.397
8/6/2024 19:04	51.43138
8/6/2024 19:04	51.39502
8/6/2024 19:04	51.37673
8/6/2024 19:05	51.39256
8/6/2024 19:05	51.36034
8/6/2024 19:05	51.37
8/6/2024 19:06	51.35751
8/6/2024 19:06	51.37481
8/6/2024 19:06	51.36552
8/6/2024 19:07	51.38525
8/6/2024 19:07	51.34411
8/6/2024 19:07	51.34361
8/6/2024 19:08	51.34734
8/6/2024 19:08	51.35152
8/6/2024 19:08	51.36024
8/6/2024 19:09	51.35478
8/6/2024 19:09	51.35498
8/6/2024 19:09	51.37128
8/6/2024 19:10	51.34967
8/6/2024 19:10	51.34492
8/6/2024 19:10	51.356
8/6/2024 19:11	51.35845
8/6/2024 19:11	51.35253
8/6/2024 19:11	51.3359
8/6/2024 19:12	51.35711
8/6/2024 19:12	51.33825
8/6/2024 19:12	51.3395
8/6/2024 19:13	51.33532
8/6/2024 19:13	51.33613
8/6/2024 19:13	51.33485
8/6/2024 19:14	51.33243
8/6/2024 19:14	51.33068
8/6/2024 19:14	51.32199
8/6/2024 19:15	51.33266
8/6/2024 19:15	51.31159
8/6/2024 19:15	51.34041
8/6/2024 19:16	51.32189
8/6/2024 19:16	51.3126
8/6/2024 19:16	51.31206
8/6/2024 19:17	51.31516
8/6/2024 19:17	51.30031
8/6/2024 19:17	51.32947
8/6/2024 19:18	51.30684
8/6/2024 19:18	51.30486
8/6/2024 19:18	51.30822
8/6/2024 19:19	51.29987

 

[RoryA]

"big hills" is not specific enough to program. What are the specific criteria?

 

[felixstraube]

Can you maybe share a bigger sample of your data uploading it to a cloud storage and sharing the link here?

 

[dmheller]

ok i compressed the data
in my file, there is a data point every 20 seconds so the high and low points might be 100 data points away from each other but this should give a better idea of what i am looking for i hope.
also, because the data is so compressed now, the noise is not there. The data will bounce a lot as you saw from the zoomed in data.
hope this helps.

date	TANK LEVEL ValueY	captures
8/6/2024 3:36	31.07967
8/6/2024 5:09	30.59689
8/6/2024 6:42	30.11036
8/6/2024 8:15	29.66054
8/6/2024 9:48	29.2001
8/6/2024 11:21	28.73083
8/6/2024 12:54	28.24494
8/6/2024 14:27	27.80097
8/6/2024 16:00	27.30139
8/6/2024 17:33	26.79192	capture
8/6/2024 19:06	51.35751	capture
8/6/2024 20:39	50.90924
8/6/2024 22:12	50.45709
8/6/2024 23:45	50.0036
8/7/2024 1:18	49.52519
8/7/2024 2:51	49.07614
8/7/2024 4:24	48.62383
8/7/2024 5:57	48.17666
8/7/2024 7:30	47.72448
8/7/2024 9:03	47.29799
8/7/2024 10:36	46.84301
8/7/2024 12:09	46.41814
8/7/2024 13:42	45.91203
8/7/2024 15:15	45.4755
8/7/2024 16:48	45.04426
8/7/2024 18:21	44.6049
8/7/2024 19:54	44.14539
8/7/2024 21:27	43.68307
8/7/2024 23:00	43.24177
8/8/2024 0:33	42.82628
8/8/2024 2:06	42.37272
8/8/2024 3:39	41.93913
8/8/2024 5:12	41.51337
8/8/2024 6:45	41.09183
8/8/2024 8:18	40.63601
8/8/2024 9:51	40.20141
8/8/2024 11:24	39.76549
8/8/2024 12:57	39.32961
8/8/2024 14:30	38.8685	capture
8/8/2024 16:03	46.29142
8/8/2024 17:36	63.10578	capture
8/8/2024 19:09	62.63246
8/8/2024 20:42	62.16714
8/8/2024 22:15	61.68335
8/8/2024 23:48	61.2369
8/9/2024 1:21	60.76647
8/9/2024 2:54	60.30705
8/9/2024 4:27	59.83383
8/9/2024 6:00	59.37236
8/9/2024 7:33	58.92715
8/9/2024 9:06	58.45534
8/9/2024 10:39	58.03059
8/9/2024 12:12	57.57697
8/9/2024 13:45	57.1493
8/9/2024 15:18	56.72015
8/9/2024 16:51	56.26521
8/9/2024 18:24	55.84282
8/9/2024 19:57	55.39269
8/9/2024 21:30	54.98111
8/9/2024 23:03	54.53223
8/10/2024 0:36	54.1008
8/10/2024 2:09	53.66565
8/10/2024 3:42	53.17788
8/10/2024 5:15	52.71405
8/10/2024 6:48	52.28931
8/10/2024 8:21	51.85918
8/10/2024 9:54	51.42114
8/10/2024 11:27	50.97546
8/10/2024 13:00	50.54375
8/10/2024 14:33	50.06662
8/10/2024 16:06	49.63488
8/10/2024 17:39	49.24515
8/10/2024 19:12	48.81021
8/10/2024 20:45	48.38075
8/10/2024 22:18	47.93177
8/10/2024 23:51	47.52581
8/11/2024 1:24	47.11427
8/11/2024 2:57	46.65405
8/11/2024 4:30	46.24913
8/11/2024 6:03	45.79699
8/11/2024 7:36	45.36763
8/11/2024 9:09	44.92515
8/11/2024 10:42	44.49461
8/11/2024 12:15	44.05156
8/11/2024 13:48	43.61631
8/11/2024 15:21	43.20103
8/11/2024 16:54	42.767
8/11/2024 18:27	42.33858
8/11/2024 20:00	41.88004
8/11/2024 21:33	41.46729
8/11/2024 23:06	41.00218
8/12/2024 0:39	40.57016
8/12/2024 2:12	40.13168
8/12/2024 3:45	39.68338
8/12/2024 5:18	39.25086
8/12/2024 6:51	38.82268
8/12/2024 8:24	38.3804
8/12/2024 9:57	37.96091
8/12/2024 11:30	37.51021	capture
8/12/2024 13:03	43.50908
8/12/2024 14:36	61.60168	capture
8/12/2024 16:09	61.15563
8/12/2024 17:42	60.69816
8/12/2024 19:15	60.27406
8/12/2024 20:48	59.83757
8/12/2024 22:21	59.40441
8/12/2024 23:54	58.9692
8/13/2024 1:27	58.51749
8/13/2024 3:00	58.09631
8/13/2024 4:33	57.64666
8/13/2024 6:06	57.24336
8/13/2024 7:39	56.81509
8/13/2024 9:12	56.37725
8/13/2024 10:45	55.97715
8/13/2024 12:18	55.53733
8/13/2024 13:51	55.12252
8/13/2024 15:24	54.67074
8/13/2024 16:57	54.25839
8/13/2024 18:30	53.76722
8/13/2024 20:03	53.33561
8/13/2024 21:36	52.87912
8/13/2024 23:09	52.41412
8/14/2024 0:42	51.99472
8/14/2024 2:15	51.56009
8/14/2024 3:48	51.14581
8/14/2024 5:21	50.69374
8/14/2024 6:54	50.26391
8/14/2024 8:27	49.84038
8/14/2024 10:00	49.39803	capture
8/14/2024 11:33	48.95198
8/14/2024 13:06	75.27502	capture
8/14/2024 14:39	74.70709
8/14/2024 16:12	74.15974
8/14/2024 17:45	73.62406
8/14/2024 19:18	73.09721
8/14/2024 20:51	72.57988
8/14/2024 22:24	72.04465
8/14/2024 23:57	71.52291
8/15/2024 1:30	71.01845
8/15/2024 3:03	70.5058
8/15/2024 4:36	69.99976
8/15/2024 6:09	69.50084
8/15/2024 7:42	69.00755
8/15/2024 9:15	68.49329
8/15/2024 10:48	68.00111
8/15/2024 12:21	67.52241
8/15/2024 13:54	67.04663
8/15/2024 15:27	66.56687
8/15/2024 17:00	66.08739
8/15/2024 18:33	65.5977
8/15/2024 20:06	65.11314
8/15/2024 21:39	64.63419
8/15/2024 23:12	64.15175
8/16/2024 0:45	63.69431
8/16/2024 2:18	63.24082
8/16/2024 3:51	62.75302
8/16/2024 5:24	62.29724
8/16/2024 6:57	61.84442
8/16/2024 8:30	61.38322
8/16/2024 10:03	60.91986
8/16/2024 11:36	60.49286
8/16/2024 13:09	60.04643
8/16/2024 14:42	59.58661
8/16/2024 16:15	59.12733	capture
8/16/2024 17:48	80.42932	capture
8/16/2024 19:21	79.78454
8/16/2024 20:54	79.16759
8/16/2024 22:27	78.58205
8/17/2024 0:00	78.00925
8/17/2024 1:33	77.4425
8/17/2024 3:06	76.87127
8/17/2024 4:39	76.32115
8/17/2024 6:12	75.79636
8/17/2024 7:45	75.25502
8/17/2024 9:18	74.72999
8/17/2024 10:51	74.18273
8/17/2024 12:24	73.65376
8/17/2024 13:57	73.10105
8/17/2024 15:30	72.5716
8/17/2024 17:03	72.05913
8/17/2024 18:36	71.53412
8/17/2024 20:09	71.02629
8/17/2024 21:42	70.54839
8/17/2024 23:15	70.06985
8/18/2024 0:48	69.57296
8/18/2024 2:21	69.10771
8/18/2024 3:54	68.64089
8/18/2024 5:27	68.17477
8/18/2024 7:00	67.71455
8/18/2024 8:33	67.23604
8/18/2024 10:06	66.77113
8/18/2024 11:39	66.3065
8/18/2024 13:12	65.81344
8/18/2024 14:45	65.35342
8/18/2024 16:18	65.32803
8/18/2024 17:51	64.93275
8/18/2024 19:24	64.35536
8/18/2024 20:57	63.76781
8/18/2024 22:30	63.276
8/19/2024 0:03	62.72043
8/19/2024 1:36	62.21566
8/19/2024 3:09	61.77072
8/19/2024 4:42	61.32814
8/19/2024 6:15	60.87821
8/19/2024 7:48	60.42633
8/19/2024 9:21	59.93715
8/19/2024 10:54	59.47975
8/19/2024 12:27	59.01949
8/19/2024 14:00	58.57765
8/19/2024 15:33	58.13668	capture
8/19/2024 17:06	89.37583	capture
8/19/2024 18:39	88.47548
8/19/2024 20:12	87.60078
8/19/2024 21:45	86.80274
8/19/2024 23:18	86.04045
8/20/2024 0:51	85.32486
8/20/2024 2:24	84.62173
8/20/2024 3:57	83.93459
8/20/2024 5:30	83.2898
8/20/2024 7:03	82.6571
8/20/2024 8:36	82.03908
8/20/2024 10:09	81.43859
8/20/2024 11:42	80.774
8/20/2024 13:15	80.20988
8/20/2024 14:48	79.59028
8/20/2024 16:21	79.01871
8/20/2024 17:54	78.47308
8/20/2024 19:27	77.9306
8/20/2024 21:00	77.37082
8/20/2024 22:33	76.84174
8/21/2024 0:06	76.31213
8/21/2024 1:39	75.80541
8/21/2024 3:12	75.29448
8/21/2024 4:45	74.79719
8/21/2024 6:18	74.29592
8/21/2024 7:51	73.7991
8/21/2024 9:24	73.30211
8/21/2024 10:57	72.8141
8/21/2024 12:30	72.32954
8/21/2024 14:03	71.83841
8/21/2024 15:36	71.36633	capture
8/21/2024 17:09	92.78713	capture
8/21/2024 18:42	91.60017
8/21/2024 20:15	90.54741
8/21/2024 21:48	89.60602
8/21/2024 23:21	88.74155
8/22/2024 0:54	87.91961
8/22/2024 2:27	87.14618
8/22/2024 4:00	86.40688
8/22/2024 5:33	85.67911
8/22/2024 7:06	84.99335
8/22/2024 8:39	84.312
8/22/2024 10:12	83.6536
8/22/2024 11:45	82.9872
8/22/2024 13:18	82.3409
8/22/2024 14:51	81.73445
8/22/2024 16:24	81.09734
8/22/2024 17:57	80.48848
8/22/2024 19:30	79.86719
8/22/2024 21:03	79.24055
8/22/2024 22:36	78.68255
8/23/2024 0:09	78.12156
8/23/2024 1:42	77.5733
8/23/2024 3:15	77.03964
8/23/2024 4:48	76.50235
8/23/2024 6:21	75.96479
8/23/2024 7:54	75.44861
8/23/2024 9:27	74.92027
8/23/2024 11:00	74.42577
8/23/2024 12:33	73.92525
8/23/2024 14:06	73.42287
8/23/2024 15:39	72.91615
8/23/2024 17:12	72.41404
8/23/2024 18:45	71.90439	capture
8/23/2024 20:18	84.84488	capture
8/23/2024 21:51	84.13911
8/23/2024 23:24	83.46046
8/24/2024 0:57	82.77746
8/24/2024 2:30	82.12297
8/24/2024 4:03	81.49693
8/24/2024 5:36	80.89736
8/24/2024 7:09	80.2484
8/24/2024 8:42	79.61418
8/24/2024 10:15	79.01535
8/24/2024 11:48	78.46018
8/24/2024 13:21	77.87505
8/24/2024 14:54	77.2989
8/24/2024 16:27	76.73169
8/24/2024 18:00	76.16322
8/24/2024 19:33	75.59354
8/24/2024 21:06	75.05444
8/24/2024 22:39	74.49483
8/25/2024 0:12	73.93733
8/25/2024 1:45	73.40883
8/25/2024 3:18	72.88077
8/25/2024 4:51	72.34334
8/25/2024 6:24	71.80019
8/25/2024 7:57	71.27798
8/25/2024 9:30	70.78053
8/25/2024 11:03	70.24417
8/25/2024 12:36	69.71783
8/25/2024 14:09	69.19313
8/25/2024 15:42	68.69566
8/25/2024 17:15	68.18484
8/25/2024 18:48	67.70798
8/25/2024 20:21	67.21513
8/25/2024 21:54	66.73077
8/25/2024 23:27	66.22882
8/26/2024 1:00	65.74223
8/26/2024 2:33	65.2404
8/26/2024 4:06	64.7728
8/26/2024 5:39	64.31806
8/26/2024 7:12	63.83915
8/26/2024 8:45	63.35912
8/26/2024 10:18	62.88614
8/26/2024 11:51	62.43608
8/26/2024 13:24	61.98104
8/26/2024 14:57	61.55498
8/26/2024 16:30	61.11149
8/26/2024 18:03	60.63958
8/26/2024 19:36	60.21814
8/26/2024 21:09	59.76017
8/26/2024 22:42	59.29937
8/27/2024 0:15	58.82294
8/27/2024 1:48	58.38103
8/27/2024 3:21	57.92889
8/27/2024 4:54	57.46274
8/27/2024 6:27	57.01524
8/27/2024 8:00	56.52818
8/27/2024 9:33	56.09414
8/27/2024 11:06	55.64439
8/27/2024 12:39	55.20133
8/27/2024 14:12	54.76682
8/27/2024 15:45	54.30828
8/27/2024 17:18	53.80082
8/27/2024 18:51	53.40705
8/27/2024 20:24	52.94315
8/27/2024 21:57	52.49545
8/27/2024 23:30	52.04142
8/28/2024 1:03	51.60712
8/28/2024 2:36	51.1849
8/28/2024 4:09	50.73067
8/28/2024 5:42	50.26761
8/28/2024 7:15	49.83351
8/28/2024 8:48	49.38715
8/28/2024 10:21	48.94888
8/28/2024 11:54	48.4665	capture
8/28/2024 13:27	74.64387	capture
8/28/2024 15:00	74.05405
8/28/2024 16:33	73.52512
8/28/2024 18:06	72.98715
8/28/2024 19:39	72.46185
8/28/2024 21:12	71.94173
8/28/2024 22:45	71.4206
8/29/2024 0:18	70.88139
8/29/2024 1:51	70.35255
8/29/2024 3:24	69.84239
8/29/2024 4:57	69.33702
8/29/2024 6:30	68.82532
8/29/2024 8:03	68.34883
8/29/2024 9:36	67.84966
8/29/2024 11:09	67.32361
8/29/2024 12:42	66.81136
8/29/2024 14:15	66.3104
8/29/2024 15:48	65.81024
8/29/2024 17:21	65.33453
8/29/2024 18:54	64.83943
8/29/2024 20:27	64.35042
8/29/2024 22:00	63.86137
8/29/2024 23:33	63.38781
8/30/2024 1:06	62.90223
8/30/2024 2:39	62.40457
8/30/2024 4:12	61.94808
8/30/2024 5:45	61.48193
8/30/2024 7:18	61.02833
8/30/2024 8:51	60.57309
8/30/2024 10:24	60.11309	capture
8/30/2024 11:57	90.62952	capture
8/30/2024 13:30	89.64281
8/30/2024 15:03	88.70734
8/30/2024 16:36	87.83412
8/30/2024 18:09	87.02568
8/30/2024 19:42	86.25986
8/30/2024 21:15	85.49297
8/30/2024 22:48	84.7766
8/31/2024 0:21	84.07723
8/31/2024 1:54	83.35632
8/31/2024 3:27	82.68383
8/31/2024 5:00	82.01974
8/31/2024 6:33	81.37001
8/31/2024 8:06	80.71337
8/31/2024 9:39	80.04751
8/31/2024 11:12	79.38562
8/31/2024 12:45	78.75948
8/31/2024 14:18	78.13779
8/31/2024 15:51	77.55538
8/31/2024 17:24	76.93938
8/31/2024 18:57	76.37216
8/31/2024 20:30	75.80898
8/31/2024 22:03	75.23428
8/31/2024 23:36	74.7113
9/1/2024 1:09	74.15974
9/1/2024 2:42	73.6273
9/1/2024 4:15	73.10609
9/1/2024 5:48	72.59988
9/1/2024 7:21	72.09683
9/1/2024 8:54	71.56911
9/1/2024 10:27	71.06905
9/1/2024 12:00	70.54495
9/1/2024 13:33	70.04961
9/1/2024 15:06	69.56218
9/1/2024 16:39	69.09283
9/1/2024 18:12	68.62503
9/1/2024 19:45	68.13313
9/1/2024 21:18	67.66394
9/1/2024 22:51	67.18116
9/2/2024 0:24	66.70363
9/2/2024 1:57	66.22138
9/2/2024 3:30	65.75392
9/2/2024 5:03	65.28648
9/2/2024 6:36	64.82478
9/2/2024 8:09	64.35907
9/2/2024 9:42	63.88227
9/2/2024 11:15	63.42477
9/2/2024 12:48	62.9699
9/2/2024 14:21	62.52624
9/2/2024 15:54	62.06238
9/2/2024 17:27	61.61636
9/2/2024 19:00	61.15398
9/2/2024 20:33	60.69577
9/2/2024 22:06	60.25736
9/2/2024 23:39	59.80807
9/3/2024 1:12	59.35098
9/3/2024 2:45	58.92916
9/3/2024 4:18	58.49005
9/3/2024 5:51	58.04501
9/3/2024 7:24	57.59326
9/3/2024 8:57	57.17425
9/3/2024 10:30	56.70584
9/3/2024 12:03	56.25884	capture
9/3/2024 13:36	86.04008	capture
9/3/2024 15:09	85.27359

 

[felixstraube]

Here is a first attempt of getting the max and min values:

The file to download: HighLowDataPoints.zip

You will have to use your real data and play a little with the value in D1 to finde correctly all the points without detecting the noise as max and min.

As you can see in the image for a value of 50 it wont detect all the points correctly but with 20 it works fine.

With your real data that would be differente for sure because you have more data point between the min and max points.

If the value in D1 is too low I think it might detect wrong point (noise) as max and min.

Let me know if this works for you.

Formula in D en E:

HighLowDataPoints.xlsx
	A	B	C	D	E
1			Samples before and after to consider:	20
2		date	TANK LEVEL ValueY	Min	max
3	1	2024-08-06 03:36	31.07966614	FALSE	FALSE
4	2	2024-08-06 05:09	30.59688568	FALSE	FALSE
5	3	2024-08-06 06:42	30.11035919	FALSE	FALSE
Sheet1

Cell Formulas
Range	Formula
D3:D5	D3	=LET(span, $D$1, ignoreDp, 10, d, $B$3:$B$444, v, $C$3:$C$444, cd, B3, cv, C3, ci, MATCH(cd, d, 0), si, MAX(ci - span, 1), ei, MIN(ci + span, ROWS(d)), temp, HSTACK(ci, si, ei), s, SEQUENCE(ei-si+1,,si), fv, CHOOSEROWS(v, s), cv=MIN(fv) )
E3:E5	E3	=LET(span, $D$1, ignoreDp, 10, d, $B$3:$B$444, v, $C$3:$C$444, cd, B3, cv, C3, ci, MATCH(cd, d, 0), si, MAX(ci - span, 1), ei, MIN(ci + span, ROWS(d)), temp, HSTACK(ci, si, ei), s, SEQUENCE(ei-si+1,,si), fv, CHOOSEROWS(v, s), cv=MAX(fv) )

 

[dmheller]

this should work great. thank you. I can get it to show the value i think if true. But yes, this works and thank you again. I was trying with slopes and other things and it was not fun.

 

[felixstraube]

glad i could help. Thanks for the feedback