æ¹æ³å¦ä¸ï¼
1ãå
æâåºå·âï¼æè
âå称âï¼âââå®é
ç»´æ¤æ¶é´âæåºã
2ãå¨Dåä¸è¾å
¥ä»¥ä¸å
¬å¼ï¼
=IF(COUNTIF(A:A,A2)=COUNTIF($A$2:A2,A2),C2,"")
ä¸æå
¬å¼ï¼ä¸ä¸ºç©ºçæ°æ®å°±æ¯ä½ æéçã
追é®
ææ³å¨Gåç´æ¥å°±æ¾ç¤ºå¯¹åºçæ大çé£ä¸ªå¼ï¼è¿ä¸ªæä¹å¼åï¼