重複刪除 多出數字提取 (12291)

E2{=INDEX(B:B,SMALL(IF(ISNA(MATCH(B$2:B$10/1%+COUNTIF(OFFSET(B$2,,,ROW($1:$9)),B$2:B$10),$C$2:$C$10/1%+COUNTIF(OFFSET(C$2,,,ROW($1:$9)),C$2:C$10),)),ROW($2:$10),99),ROW(A1)))&""



留言