Mrpine的回答最简单好用了,完成之后,降序筛选即可。我的公式太长,但可一次完成
在sheet3表A1里输入下列公式,ctrl+shift+回车,然后下拉复制公式,公式太长,有待简化
=IF(LARGE(COUNTIF(Sheet1!$A$1:$A$999,Sheet2!$A$1:$A$999)*ROW($1:$999),ROW(A1))=0,"",INDEX(Sheet2!$A$1:$A$999,LARGE(COUNTIF(Sheet1!$A$1:$A$999,Sheet2!$A$1:$A$999)*ROW($1:$999),ROW(A1)),))
温馨提示:答案为网友推荐,仅供参考