jonastiger
Member
Hello
I need help with some formulas (those below) to calculate MIN/MAX in a range by section.
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
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
Attachments
Last edited: