æ¨è楼主ä¸ä¸ªæ¹æ³ï¼ççæ没æåç¨ç
æ¹æ³ä¸ï¼éå¤è®°å½å æ°åç¼å·çæ¹æ³æ¾å°éå¤å¼
å设å
³é®ååæ¾å¨Båï¼ä»B2åå
æ ¼å¼å§å°B100ã
C2åå
æ ¼å
¬å¼ï¼
=B2&IF(COUNTIF($B$2:$B$100,B2)>1,COUNTIF(B$2:$B$100,B2),"")
Cåä¸æ°æ®å¸¦ç¼ç çæéå¤ï¼ä¸ç¼ç å°±æ¯åºç°éå¤ç次æ°ï¼
æ¹æ³äºï¼çé
éä¸è¿å:æ°æ®ââçéââé«çº§çéââéæ©ä¸éå¤è®°å½ï¼å¾ä¸ï¼ââç¡®å®ã
è¿æ ·å°±å¯ä»¥æç¸åçç¸é»æ¾ç¤ºä»¥ä¾¿è§å¯éå¤æ
åµï¼
æ¹æ³ä¸ï¼
å设æ°æ®ä»A2å¼å§è³A100
å¨B2ä¸åå
¥å
¬å¼ååä¸å¤å¶å°±å¯ä»¥æéå¤çæ°æ®å¨Båä¸ååºæ¥ã
B2=IF(COUNTIF($A$2:$A$100,A2)>1,A2,"")
Båæå¼çå°±æ¯åºé¡¹éå¤çæ°æ®è¡
温馨提示:答案为网友推荐,仅供参考