表3的A2中输入=INDEX(Sheet1!A:A,SMALL(IF(COUNTIF(Sheet2!$C:$C,Sheet1!$A$2:$A$100),ROW($2:$100),4^8),ROW(A1)))&""同时按下CTRL+SHIFT+回车,输入数组公式,右拉,下拉。表4的A2输入=INDEX(Sheet1!A:A,SMALL(IF(COUNTIF(Sheet2!$C:$C,Sheet1!$A$2:$A$100)=0,ROW($2:$100),4^8),ROW(A1)))&""同时按下CTRL+SHIFT+回车,右拉,下拉。这里假设你表1的数据在A2:E100中。表2的数据在A列到C列。...
|