Excel 将AB两表某列相同的那项从B复制到A | 筛选出相同数据
筛选出相同数据
=IF(COUNTIF(B:B,A1)>0,A1,"")
将AB两表某列相同的那项从B复制到A
=INDEX('[tmp001.xls]SQL Results'!$C:$C,MATCH(E3486,'[tmp001.xls]SQL Results'!$B:$B,))
=INDEX('[tmp001.xls]SQL Results'!$C:$C,MATCH(D118629,...
原创
2019-01-28 15:38:51 ·
2583 阅读 ·
0 评论