#### 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: