æå¤ç§å ¬å¼é½å¯ä»¥è¾¨å«ä¸¤åæ°æ®æ¯å¦æéå¤ï¼
=IF(EXACT(åå æ ¼A,åå æ ¼B)=TRUE,"ç¸å","ä¸å")
=IF(COUNTIF(A:A,B1)=0,"ä¸éå¤","")
=IF(åå
æ ¼A=åå
æ ¼B,"ç¸å","ä¸å")
å ·ä½æ¡ä¾åèç¾åº¦ç»éªhttp://jingyan.baidu.com/article/c85b7a6403d7d1003bac95f8.html
可以用条件格式,如果这两列内容是在A、B列,
条件格式公式=COUNTIFS($A:$A,$A1,$B:$B,$B1)>1
方法请参考:
excel条件格式公式怎么用_百度经验
http://jingyan.baidu.com/article/5225f26b0a1c50e6fa090814.html