假设第一个表格里有500个姓名在sheet1的A列,即从A1到A500,第二个表格里有502个姓名,那是在sheet2的A列,即从A1到A502,则可以在其他任一单元格输入=IF(ISERROR(INDEX(Sheet2!$A$1:$A$600,SMALL(IF(ISERROR(MATCH(Sheet2!$A$1:$A$600,Sheet1!$A$1:$A$600,0)),IF(Sheet2!$A$1:$A$600<>"",ROW(Sheet2!$A$1:$A$600),"0"),"0"),ROW(A1)))),"",INDEX(Sheet2!$A$1:$A$600,SMALL(IF(ISERROR(MATCH(Sheet2!$A$1:$A$600,Sheet1!$A$1:$A$600,0)),IF(Sheet2!$A$1:$A$600<>"",ROW(Sheet2!$A$1:$A$600),"0"),"0"),ROW(A1))))然后按CTRL+SHIFT+ENTER使其生成数组,再向下拉该单元格就可以分别拉出那两个不重复的姓名,如是要还有更多不同姓名,再向下拉会自动生成!
温馨提示:答案为网友推荐,仅供参考