Planner calculation

[jonastiger]

Hello
I need help with some formulas (those below) to calculate MIN/MAX in a range by section.

COL N	=IF(G3="";MIN(G4:INDEX(G4:G$9941;MATCH(TRUE;INDEX(ISBLANK(G4:G$9941);0;1);0)));G3)
COL O	=IF(H3="";MAX(H4:INDEX(H4:H$9941;MATCH(TRUE;INDEX(ISBLANK(H4:H$9941);0;1);0)));H3)
COL P	=IFERROR(IF(A3<A4; MIN(INDIRECT("N" & ROW()+1 & ":N" & MATCH(A3; A4:A$9942;0)));L3);"")
COL Q	=IFERROR(IF(A3<A4; MAX(INDIRECT("O" & ROW()+1 & ":O" & MATCH(A3; A4:A$9942;0)));M3);"")

They should calculate MIN/MAX sections in yellow cells. Some are calculated, some not.


The file attached shows my issue.
Thank you all in advance

 

[jonastiger]

I made a good progress:

COL N	=IFERROR(IF(ISNA(MATCH($A3;$A4:$A$9942;0));MIN(G4:G$9942);IF($A3<$A4; MIN(INDIRECT("g" & ROW()+1 & ":g" & MATCH($A3;$A4:$A$9942;0)));G3));"")
COL O	=IFERROR(IF(ISNA(MATCH($A3;$A4:$A$9942;0));MAX(H4:H$9942);IF($A3<$A4; MAX(INDIRECT("H" & ROW()+1 & ":H" & MATCH($A3;$A4:$A$9942;0)));H3));"")
COL P	=IFERROR(IF(ISNA(MATCH($A3;$A4:$A$9942;0));MIN(L4:L$9942);IF($A3<$A4; MIN(INDIRECT("L" & ROW()+1 & ":L" & MATCH($A3;$A4:$A$9942;0)));L3));"")
COL Q	=IFERROR(IF(ISNA(MATCH($A3;$A4:$A$9942;0));MAX(M4:M$9942);IF($A3<$A4; MAX(INDIRECT("M" & ROW()+1 & ":M" & MATCH($A3;$A4:$A$9942;0)));M3));"")

But still misses something, because last cells don't calculate.


Someone help me with that?