아래 이미지 참고하세요

=LET(rngAl,A2:G29, CnA,INDEX(rngAl,,1), CnC,INDEX(rngAl,,3), CnD,INDEX(rngAl,,4), CnE,INDEX(rngAl,,5), vCnE,IFERROR(--CnE,0),

xKeys,CnA&"|"&CnC&"|"&CnD, xMax,MAP(xKeys,LAMBDA(ikey, MAX(FILTER(vCnE,xKeys=ikey)))), xFT,FILTER(rngAl,vCnE=xMax),

SORT(UNIQUE(xFT),{1,3,4},{1,1,1}))