è§æ ·è¡¨æªå¾
sheet2çA1è¾å ¥ï¼å¤å¶ç²è´´æ¤å ¬å¼ï¼
=INDEX(Sheet1!A:A,SMALL(IF((Sheet1!$A$1:$A$100="")*(Sheet1!$B$1:$B$100=""),4^8,ROW($1:$100)),ROW(A1)))&""
æ°ç»å ¬å¼ï¼å æä½CTRL+SHIFT,æåå车
å ¬å¼å³æä¸æ
追é®sheet2çA1è¾å ¥
=INDEX(Sheet1!A:A&Sheet1!B:B,SMALL(IF((Sheet1!$A$1:$A$100="")*(Sheet1!$B$1:$B$100=""),4^8,ROW($1:$100)),ROW(A1)))&""
æ°ç»å ¬å¼ï¼ä¸é®è¾å ¥
å ¬å¼ä¸æ
åçé®é¢åªæ¯åçæ§çï¼è³äºå¤å°è¡ä½ èªå·±æ¹ï¼1:100å¯æ¹ä¸º1:100000é½æ²¡å ³ç³»
用函数