A | B | =COUNTIF($A$1:$A$3,B1)=0 |
B | B | =COUNTIF($A$1:$A$3,B2)=0 |
C | A | =COUNTIF($A$1:$A$3,B3)=0 |
最终显示结果,B和A都属于第一列,D不属于第一列
A | B | FALSE |
B | A | FALSE |
C | D | TRUE |
A | B | =COUNTIF($A$1:$A$3,B1)=0 |
B | B | =COUNTIF($A$1:$A$3,B2)=0 |
C | A | =COUNTIF($A$1:$A$3,B3)=0 |
最终显示结果,B和A都属于第一列,D不属于第一列
A | B | FALSE |
B | A | FALSE |
C | D | TRUE |