第1个回答 2019-10-24
B2用公式:(从截图看,应该是2003版本的EXCEL,所以公式比较长)
=IF(ISERROR(INDEX(Sheet2!B$2:B$100,SMALL(IF(MATCH(IF(Sheet2!A$2:A$100=A$2,Sheet2!B$2:B$100),IF(Sheet2!A$2:A$100=A$2,Sheet2!B$2:B$100),)=ROW($1:$99),ROW($2:$100),9^9),ROW(A1)))),"",INDEX(Sheet2!B$2:B$100,SMALL(IF(MATCH(IF(Sheet2!A$2:A$100=A$2,Sheet2!B$2:B$100),IF(Sheet2!A$2:A$100=A$2,Sheet2!B$2:B$100),)=ROW($1:$99),ROW($2:$100),9^9),ROW(A1)))&"")
数组公式,按组合键(CTRL+SHIFT+回车)完成公式,下拉。