C2è¾å ¥
=IF(COUNTIF(A$2:A2,A2)=1,A2,"")
D2è¾å ¥
=IF($C2="","",INDEX($B:$B,SMALL(IF($A$2:$A$1000=$C2,ROW($2:$1000),4^8),COLUMN(A1)))&"")
æ°ç»å ¬å¼ï¼å æä½CTRL+SHIFT,æåå车ï¼ä½¿å¾ç¼è¾æ å ¬å¼ä¸¤ç«¯åºç°è±æ¬å·{ }
å ¬å¼ä¸æåå³æå°æ æ°æ®
追é®é常æè°¢ï¼æ³è¿½é®ä¸å¥ï¼å¦ææ³å¨æ°çä¸ä¸ªsheetï¼åè¿æ ·çæ¾ç¤ºï¼åºè¯¥æä¹ç¼è¾å¢ï¼
sheet2çA2è¾å ¥
=INDEX(Sheet1!A:A,MIN(IF(COUNTIF(A$1:A1,Sheet1!$A$2:$A$1000)=0,ROW($2:$1000),4^8)))&""
æ°ç»å ¬å¼ï¼å æä½CTRL+SHIFT,æåå车ï¼ä½¿å¾ç¼è¾æ å ¬å¼ä¸¤ç«¯åºç°è±æ¬å·{ }
å ¬å¼ä¸æå°æ æ°æ®
B2è¾å ¥
=INDEX(Sheet1!$B:$B,SMALL(IF(Sheet1!$A$2:$A$1000=--$A2,ROW($2:$1000),4^8),COLUMN(A1)))&""
æ°ç»å ¬å¼ï¼å æä½CTRL+SHIFT,æåå车ï¼ä½¿å¾ç¼è¾æ å ¬å¼ä¸¤ç«¯åºç°è±æ¬å·{ }
å ¬å¼ä¸æåå³æå°æ æ°æ®