May 17 2024 11:43 AM
Kindly Sort it
May 17 2024 12:23 PM
@AlexEanbu
=MAX( FILTER($D$3:$I$29, $C$3:$C$29=$N9) )
and
=MAX( BYCOL( FILTER($D$3:$I$29, $C$3:$C$29=$N9), LAMBDA(v, SUM(v) ) ) )
May 17 2024 12:31 PM
Alternatively
=MAX( $D$3:$I$29*($C$3:$C$29=$N9) )
=MAX( MMULT(SEQUENCE(,ROWS($C$3:$C$29),,0),($C$3:$C$29=$N18)*$D$3:$I$29) )
