G2:H11{=INDEX(A:A,MIN(IF(COUNTIFS($G$1:$G1,$A$2:$A$19,$H$1:$H1,$B$2:$B$19)=0,ROW($2:$19),4^8)))&""
另解G2:H11{=INDEX(A:A,SMALL(IF(MATCH($A$2:$A$19&$B$2:$B$19,$A$2:$A$19&$B$2:$B$19,)=ROW($1:$18),ROW($2:$19),4^8),ROW(A1)))&""
I2:I11{=IF(G2="","",INDEX(C:C,RIGHT(MAX((A$2:A$19=G2)*(B$2:B$19=H2)*D$2:D$19/1%+ROW($2:$19)),2)))
另解I2:I11=IF(G2="","",LOOKUP(,0/FREQUENCY(-9^9,-(A$2:A$19=G2)*(B$2:B$19=H2)*D$2:D$19),C$2:C$19))
K2:L11{=INDEX(A:A,RIGHT(MIN(IF(COUNTIFS($K$1:$K1,$A$2:$A$19,$L$1:$L1,$B$2:$B$19)=0,MATCH($B$2:$B$19,$B:$B,)/1%+ROW($2:$19),9999)),2))&""
留言
張貼留言