H2:I7{=OFFSET($B$1,RIGHT(LARGE(IF((INT($A$2:$A$29)=LOOKUP(9^9,$F$2:$F2))*(MATCH(INT($A$2:$A$29)&$B$2:$B$29&$C$2:$C$29,INT($A$2:$A$29)&$B$2:$B$29&$C$2:$C$29,)=ROW($1:$28)),MMULT(N($B$2:$B$29&$C$2:$C$29&INT($A$2:$A$29)=TRANSPOSE($B$2:$B$29&$C$2:$C$29&INT($A$2:$A$29))),ROW(2:29)^0)/1%+ROW($1:$28)),RIGHT($G2)),2),$B$1=B$1)
J2:J7=SUMPRODUCT((INT(A$2:A$29)=LOOKUP(9^9,$F$2:$F2))*(B$2:B$29=I2)*(C$2:C$29=H2))
留言
張貼留言