é¦å
è¦æ¾å°æ°æ®ä¸å¯ä¸çåï¼å³æåæææ°æ®ä¸æ¯ä¸ä¸ªåå
æ ¼çæ°æ®é½æ¯å¯ä¸çï¼æ¯å¦è¯´å¦ææåºå·åï¼å°±åºè¯¥æ¯åºå·è¿ä¸åãç¶åæå¦ä¸ä¸ªè¡¨ç该åæ°æ®å¤å¶ï¼ç²è´´å¨è¡¨ç对åºåçä¸æ¹ï¼ç©ºç½åå
æ ¼ï¼ãå¦æè¿ä¸åå¨Aåçè¯ï¼ç¶åå¨è¯¥ååæå
¥ä¸åè¾
å©åï¼å³æå
¥åçBåï¼å¨è¿ä¸åä¸B2è¾å
¥å»éå¤å
¬å¼ï¼=INDEX(A:A,1+MATCH(,COUNTIF(A$1:A1,A$2:A$999),))&""ï¼åæ¶æctrl+shift+enter,åæè¿ä¸ªä½å
¬å¼åä¸å¤å¶ã
æ¥ä¸æ¥å°±æ¯å©ç¨vlookupè¿ä¸ªå
¬å¼æ表ä¸æ°å¢çæ°æ®ï¼ä»å¦ä¸ä¸ªè¡¨ä¸æ¾åºæ¥ã
追é®éº»ç¦é®ä¸ãããVLOOKUPè¿ä¸ªå
¬å¼æ¯å¥ããææ¯å°ç½ãã