ããèªå¨æ¥æ¾excelè¡¨æ ¼ä¸çå
容çæ¹æ³
ããæè¿éåä¸ä¸ªä¾åï¼é¦å
æå¼éè¦æ¥æ¾éå¤å
容çè¡¨æ ¼ã
ããæ们è¿éæ¥æ¾Håæ¯å¦æéå¤çå
容ï¼
ããä¸ãä»æå
容çå°æ¹å¼å§éä¸ï¼ç´å°æåä¸è¡ï¼æè¿éæ¯8748è¡ï¼æå
容çè¡æ¯ç¬¬å
è¡ï¼ä¹å°±æ¯h6å°h8748ã
ããäºãç¹å»ï¼æ ¼å¼--->æ¡ä»¶æ ¼å¼ãï¼H6-H8748çç¶æè¿æ¯è¢«éä¸å¦ï¼ï¼
ããå¨æ¡ä»¶æ ¼å¼ççªå£ä¸éæ©æ¡ä»¶ä¸ºâå
¬å¼âã
ããå¨å
¬å¼è¾å
¥æ¡ä¸è¾å
¥ï¼
ãã=COUNTIF($h$6:$h$8748,$h2)>1
ããPSï¼å¦æä½ éæ©çæ¯Cåï¼å
容æ¯ä»ç¬¬2åå°1000åï¼é£ä¹å¯ä»¥æ ¹æ®ä¸è¿°å
¬å¼æ¹ä¸ºï¼=COUNTIF(C$2:H$1000,$C2)>1ã
ããç¶åå¨âæ¡ä»¶å
¬å¼âèåä¸ç¹å»âæ ¼å¼âã
ããéæ©ä¸ä¸ªé¢è²ï¼ç¨æ¥æ è¯éå¤ï¼ç¸åï¼çå
容ã
ããæéçæ¯çº¢è²ã
ããæåç¹å»âç¡®å®âã
ããç¨å¾®çå¾
ä¸ä¸ä¾¿æåå¦ï¼
温馨提示:答案为网友推荐,仅供参考