二項取不重複 與多維提出 (14561)

(取A B不重複)A17:B23{=IFERROR(INDEX(A:A,SMALL(IF(COUNTIFS($A$16:$A16,$A$2:$A$13,$B$16:$B16,$B$2:$B$13)=0,ROW($2:$13)),1)),"")

C17:K23{=OFFSET($C$1,SMALL(IF(($A$2:$A$13=$A17)*($B$2:$B$13=$B17),ROW($1:$12),99),INT(COLUMN(C1)/3)),MOD(COLUMN(C1),3))&""



留言