二項 不重複 (10022)


D2:E11=LOOKUP(1,0/FREQUENCY(1,(COUNTIFS($D$1:$D1,$A$2:$A45,$E$1:$E1,$B$2:$B45)=0)*1),A$2:A45)&""


另解 G2:H11{=INDEX(A:A,SMALL(IF(MATCH($A$2:$A$46&$B$2:$B$46,$A$2:$A$46&$B$2:$B$46,)=ROW($1:$45),ROW($2:$46),4^8),ROW(A1)))&""


留言