ç¨æ°ç»å
¬å¼å¯å®ç°
={INDEX(C:C,SMALL(IF($C$2:$C$200="",65536,ROW($C$2:$C$200)),ROW(A1)))&""}
å¯ä»¥å°è¿ä¸ªå
¬å¼ï¼å¤å¶å°ç¬¬ä¸ä¸ªè¡¨æ ¼D1ä¸å
è¯è¯ç
æ°ç»å
¬å¼ï¼è¦ctrl+shift+enterä¸é®ç»æ
å°å
¶ä¸çåå
æ ¼ï¼æ¹æä½ è¡¨éçåå
æ ¼å³å¯
è¿æ¯æåCåçå¼ï¼åçï¼BåãAåå
¬å¼ä¸º
={INDEX(B:B,SMALL(IF($C$2:$C$200="",65536,ROW($C$2:$C$200)),ROW(A1)))&""}
={INDEX(A:A,SMALL(IF($C$2:$C$200="",65536,ROW($C$2:$C$200)),ROW(A1)))&""}
追é®è¯·é®65536æ¯ä»ä¹ææå
追ç65536æ¯æ大è¡ï¼ä¹å°±æ¯å½åå
æ ¼æ¶ç©ºå¼æ¶ï¼è¡æ°=65536ï¼ä»èå¨ç¨smallæåºæ¶ï¼æå°æåé¢