假设上表为SHEET1表在SHEET2表的A1输入:=INDEX(SHEET1!A:A,SMALL(IF(MATCH(SHEET1!A$1:A$100&"",SHEET1!A$1:A$100&"",)=ROW($1:$100),ROW($1:$100),4^8),ROW(A1)))&""数组公式,按CTRL+SHIFT+回车结束下拉填充(若SHEET1表记录较多,可把公式中的100改成更大数值)在SHEET2表的B1输入:=INDEX(SHEET1!$B:$B,SMALL(IF(SHEET1!$A$1:$A$100=$A1,ROW($1:$100),4^8),COLUMN(A1)),)数组公式,按CTRL+SHIFT+回车结...
|