å ¬å¼æ¯è¾ç®åï¼ä½çä½ çæªå¾ï¼Aï¼Bï¼Cä¸åçæ°åä¸ï¼æçæ¯çº¯æ°åï¼æçæ¯ææ¬æ°åï¼ç´æ¥å¤æå°±å¯è½è¯¯å¤ãæä»¥ä½ å è¦æ3åæ°æ®ç»ä¸æ ¼å¼ï¼è¦ä¸é½æ¯ææ¬ï¼è¦ä¸é½æ¯æ°åãä¸ç»ä¸çè¯ï¼å°±è¦ç¨æ°ç»æ¥ç»ä¸ï¼ä¸æ¯å¥½æ¹æ³ãä¸é¢ç»ä½ ä¸¤ä¸ªå ¬å¼ï¼åå«å¦å¾ä¸çDååEåï¼
D1=IF(OR(A1=B1,A1=C1,B1=C1),"åæ ¼","ä¸åæ ¼")
E1=IF(SUMPROCUCT(COUNTIF(A1:B1,A1:C1))=3,"ä¸åæ ¼","åæ ¼")