Spreadsheet: 785922d1656840001-i-have-2022-07-04-oeldere3-aslam-5420-numbers
Sheet: Sheet1

Time | value | average | criteria | help |  |  |  |  | Expected Results #1 | Expected Results #1 |  | Hi,
00:25:00 | 2.343508127382603
00:26:00 | 2.304937295600308 |  |  |  |  |  |  |  |  |  |  | I have values in Column C from cell C12 onward.
00:27:00 | 2.26176143257315 |  |  |  |  |  |  |  |  |  |  | From cell C3 to C23, these values gradually becomes smaller and smaller. In this range, every lower cell value is smaller than its upper cell value. But at Cell C24 a value comes that is bigger than the upper cell value. I want this value in the adjacent cell D24.
00:28:00 | 2.234614970855898
00:29:00 | 2.207174125113238 |  |  |  |  |  |  |  |  |  |  | Now from C24 onward,
00:30:00 | 2.168727033718125 |  |  |  |  |  |  |  |  |  |  | From cell C24 to C45, these values gradually becomes bigger and bigger. In this range, every lower cell value is bigger than its upper cell value. But at Cell C46 a value comes that is smaller than the upper cell value. I want this value in the adjacent cell D46.
00:31:00 | 2.154003790787837 |  |  |  |  |  |  |  |  |  |  | and so on,
00:32:00 | 2.145830266659684 |  |  |  |  |  |  |  | criteria | yes
00:33:00 | 2.078744682038956 |  |  |  |  |  |  |  |  |  |  | Also,
00:34:00 | 1.957652048139064 |  |  |  |  |  |  |  | Rijlabels | average |  | In cell E12, I want value of D24. In cell [NAME], i want value of D46 and so on. (Actually values in column D are further apart with blank cells in between them, so i want values these values from cell E12 onward without blank ells)
00:35:00 | 1.858725887127602 |  |  |  |  |  |  |  | 1 | 1.855050760865051
00:36:00 | 1.779809654003213 |  |  |  |  |  |  |  | 2 | 2.240271076567477 |  | File is attached for further help
00:37:00 | 1.758233577862993 |  |  |  |  |  |  |  | 3 | 1.59400430108019
00:38:00 | 1.719206924729033 |  |  |  |  |  |  |  | 4 | 1.8981758750969
00:39:00 | 1.675488527832312 |  |  |  |  |  |  |  | 5 | 1.698420399178724
00:40:00 | 1.746894472966414 |  |  |  |  |  |  |  | 6 | 1.713381278691515
00:41:00 | 1.795923125445083 |  |  |  |  |  |  |  | 7 | 1.711977897028337
00:42:00 | 1.863157276242387 |  |  |  |  |  |  |  | 8 | 1.802597432392786
00:43:00 | 1.9088688499298 |  |  |  |  |  |  |  | 9 | 1.80546212264901
00:44:00 | 1.991840950682868 |  |  |  |  |  |  |  | 10 | 2.202495864022434
00:45:00 | 2.066684152689587 |  |  |  |  |  |  |  | 11 | 2.015556025418924
00:46:00 | 2.095775730869332 |  |  |  |  |  |  |  | 12 | 2.019804052885423
00:47:00 | 2.125944053023045 |  |  |  |  |  |  |  | 13 | 1.165649053631234
00:48:00 | 2.157808760658892 |  |  |  |  |  |  |  | Eindtotaal | 1.824834318423693
00:49:00 | 2.168143688172347
00:50:00 | 2.181834657726523
00:51:00 | 2.157714082217933
00:52:00 | 2.182261049187358
00:53:00 | 2.208122507078639
00:54:00 | 2.216610857197691
00:55:00 | 2.240507873875612
00:56:00 | 2.248364421143219
00:57:00 | 2.242766394972304
00:58:00 | 2.215442968257517
00:59:00 | 2.191911018913939
01:00:00 | 2.228814351833788
01:01:00 | 2.220350417775717
01:02:00 | 2.252142487470675
01:03:00 | 2.280251459596667
01:04:00 | 2.314966449614528
01:05:00 | 2.285937265729769
01:06:00 | 2.227319674187823
01:07:00 | 2.174986009313781
01:08:00 | 2.183693411371846
01:09:00 | 2.183088744478636
01:10:00 | 2.134032794696464
01:11:00 | 2.045660950340658
01:12:00 | 1.993783739516698
01:13:00 | 1.983215739702868
01:14:00 | 1.983993338256678
01:15:00 | 1.900317743525261
01:16:00 | 1.817639511259625
01:17:00 | 1.784229049954516
01:18:00 | 1.727178357479514
01:19:00 | 1.673714956167427
01:20:00 | 1.647283915752934
01:21:00 | 1.637866047442398
01:22:00 | 1.616517392242483
01:23:00 | 1.614383632273996
01:24:00 | 1.610097824523476
01:25:00 | 1.570271646661678
01:26:00 | 1.544615562619964
01:27:00 | 1.56178398039219
01:28:00 | 1.582394176875948
01:29:00 | 1.595893400025585
01:30:00 | 1.586676057478709
01:31:00 | 1.58704792804765
01:32:00 | 1.578495428601099
01:33:00 | 1.623276285973756
01:34:00 | 1.673115689488239
01:35:00 | 1.722122450766105
01:36:00 | 1.786750284237183
01:37:00 | 1.828179495255978
01:38:00 | 1.850243070894589
01:39:00 | 1.883686122225168
01:40:00 | 1.921834539965926
01:41:00 | 1.95342279272617
01:42:00 | 1.99163669112549
01:43:00 | 1.97589388569902
01:44:00 | 1.939914264516486
01:45:00 | 1.869822945760742
01:46:00 | 1.850465668151426
01:47:00 | 1.861664773521309
01:48:00 | 1.856311767488901
01:49:00 | 1.823213979087581
01:50:00 | 1.821884213484421
01:51:00 | 1.844661357658762
01:52:00 | 1.858145885343401
01:53:00 | 1.858372841388712
01:54:00 | 1.891686008189009
01:55:00 | 1.823544631657182
01:56:00 | 1.73939347190537
01:57:00 | 1.680432951052464
01:58:00 | 1.653607096241186
01:59:00 | 1.673004422571492
02:00:00 | 1.696965240379325
02:01:00 | 1.750234083500783
02:02:00 | 1.755419255934964
02:03:00 | 1.74847978412775
02:04:00 | 1.717601510955373
02:05:00 | 1.671191450652725
02:06:00 | 1.670018993713026
02:07:00 | 1.658672835213704
02:08:00 | 1.68056774994825
02:09:00 | 1.705282366906115
02:10:00 | 1.73128632757786
02:11:00 | 1.732157962547728
02:12:00 | 1.748827671284258
02:13:00 | 1.741069435436427
02:14:00 | 1.720164043413899
02:15:00 | 1.766894416690687
02:16:00 | 1.813513433740152
02:17:00 | 1.841006812525433
02:18:00 | 1.82041607724295
02:19:00 | 1.787116600001764
02:20:00 | 1.781333629513651
02:21:00 | 1.808742030076954
02:22:00 | 1.776167505958992
02:23:00 | 1.74794339155363
02:24:00 | 1.768999217685572
02:25:00 | 1.810874873855238
02:26:00 | 1.817291699927122
02:27:00 | 1.835500988730712
02:28:00 | 1.84271908122663
02:29:00 | 1.834064092940221
02:30:00 | 1.854792360317643
02:31:00 | 1.893758468829102
02:32:00 | 1.930056605482446
02:33:00 | 2.00429524125951
02:34:00 | 2.079812175372465
02:35:00 | 2.148769178733088
02:36:00 | 2.19808000269104
02:37:00 | 2.238695833396645
02:38:00 | 2.245951018896503
02:39:00 | 2.245972021565675
02:40:00 | 2.251652613154758
02:41:00 | 2.25962854544643
02:42:00 | 2.25718657165275
02:43:00 | 2.229778340655966
02:44:00 | 2.167725984853289
02:45:00 | 2.117847632189066
02:46:00 | 2.068662625034006
02:47:00 | 2.048820666436368
02:48:00 | 2.069504936293638
02:49:00 | 2.049989706850835
02:50:00 | 2.043076182850339
02:51:00 | 2.033829676207771
02:52:00 | 2.044558713154939
02:53:00 | 2.029254582977896
02:54:00 | 2.052919386024638
02:55:00 | 2.037523782872936
02:56:00 | 2.036293338433564
02:57:00 | 2.046892923691229
02:58:00 | 2.052520599620292
02:59:00 | 2.029220110965039
03:00:00 | 1.994688729699928
03:01:00 | 1.977757434068278
03:02:00 | 1.971059040806236
03:03:00 | 1.960967034224237
03:04:00 | 1.986781364859721
03:05:00 | 2.025914742253772
03:06:00 | 2.040815083605222
03:07:00 | 2.063761902799581
03:08:00 | 2.079987907549605
03:09:00 | 2.060689331128114
03:10:00 | 2.046005952665351
03:11:00 | 1.998330873212592
03:12:00 | 1.961407880784219
03:13:00 | 1.941625959300052
03:14:00 | 1.922576009883127
03:15:00 | 1.886846550825606
03:16:00 | 1.863185617936392
03:17:00 | 1.832178498231866
03:18:00 | 1.821934418711433
03:19:00 | 1.812917724856842
03:20:00 | 1.805444044772952
03:21:00 | 1.795594933085906
03:22:00 | 1.789261926116436
03:23:00 | 1.758394049703125
03:24:00 | 1.718387661633398
03:25:00 | 1.664737213298036
03:26:00 | 1.637623759892304
03:27:00 | 1.590368219361989
03:28:00 | 1.531539881688826
03:29:00 | 1.440064233862938
03:30:00 | 1.368565487174703
03:31:00 | 1.312894782650599
03:32:00 | 1.26571238129807
03:33:00 | 1.21048158387033
03:34:00 | 1.187785300029586
03:35:00 | 1.160763592746588
03:36:00 | 1.137521359487874
03:37:00 | 1.11319742904885
03:38:00 | 1.107847370396638
03:39:00 | 1.108409605123282
03:40:00 | 1.113916659622814
03:41:00 | 1.134243649220761
03:42:00 | 1.195066861592718
03:43:00 | 1.219517334401598
03:44:00 | 1.241357250882612
03:45:00 | 1.268162231021489
03:46:00 | 1.279246905135761
03:47:00 | 1.288019833229453