i am very unfamiliar with whatever you are actually doing
so not quite sure what the "desired" is in column G
what i gave you previously was the representative ROW of the time frame range
so for E-09
14:48:12 starts at Row 56
14:48:42 ends at Row 196
to get the maximum VALUE of this range it would be max(B56:B196) right?
if so then the formula would be
Formula:
=MAX(INDIRECT("B"&MIN(IF(MOD($A$2:$A$3259,1)>=J15,ROW($A$2:$A$3259)-2))&":B"&MAX(IF(MOD($A$2:$A$3259,1)<=K15+TIME(,,1),ROW($A$2:$A$3259)-2))))
...
min value would be
Formula:
=MIN(INDIRECT("B"&MIN(IF(MOD($A$2:$A$3259,1)>=J15,ROW($A$2:$A$3259)-2))&":B"&MAX(IF(MOD($A$2:$A$3259,1)<=K15+TIME(,,1),ROW($A$2:$A$3259)-2))))
both CSE formula as per usual
updated file with these two formulas showing now attached
Bookmarks