Forum Discussion
MAX IN ARRAY
Kindly Sort it
Alternatively
=MAX( $D$3:$I$29*($C$3:$C$29=$N9) )and
=MAX( MMULT(SEQUENCE(,ROWS($C$3:$C$29),,0),($C$3:$C$29=$N18)*$D$3:$I$29) )Alternatively
=MAX( $D$3:$I$29*($C$3:$C$29=$N9) )and
=MAX( MMULT(SEQUENCE(,ROWS($C$3:$C$29),,0),($C$3:$C$29=$N18)*$D$3:$I$29) )