問題:找出AB兩列,共同存在,分別單獨存在的內容
問題:找出AB兩列,共同存在,分別單獨存在的內容
AB重復
=IFERROR(INDEX(A:A,SMALL(IF(COUNTIF(B:B,$A$1:$A$37),ROW($A$1:$A$37),""),ROW(A1))),"")
A單獨
=IFERROR(INDEX(A:A,SMALL(IF(COUNTIF(B:B,$A$1:$A$37),"",ROW($1:$37)),ROW(A1)))&"","")
B單獨
=IFERROR(INDEX(B:B,SMALL(IF(COUNTIF(A:A,$B$1:$B$37),"",ROW($1:$37)),ROW(A1)))&"","")
都要數(shù)組3鍵
UP:小賴同學愛學習
點贊加速出視頻
