sheet3先求出SHEET1中有SHEET2中没有的姓名,再求出SHEET2中有SHEET1中没有的姓名B2=INDEX(Sheet1!B:B,SMALL(IF(ISERROR(MATCH(Sheet1!B$2:B$2000,Sheet2!B$2:B$2000,0)),ROW($2:$2000),""),ROW(A1)))按CTRL+SHIFT+ENTER结束公式输入,下拉填充至出现空白。在出现的第一个空白处输入公式=INDEX(Sheet2!B:B,SMALL(IF(ISERROR(MATCH(Sheet2!B$2:B$2000,Sheet1!B$2:B$2000,0)),ROW($2:$2000),""),ROW(A1)))按CTRL...
|