Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more >
SergeiBaklanMVPMay 17, 2024AlexEanbu 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) )MAX.xlsx14 KBSergeiBaklanMVPMay 17, 2024AlexEanbu =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) ) ) ) MAX.xlsx14 KB
SergeiBaklanMVPMay 17, 2024AlexEanbu 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) )MAX.xlsx14 KB
SergeiBaklanMVPMay 17, 2024AlexEanbu =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) ) ) ) MAX.xlsx14 KB