|
楼主 |
发表于 2015-11-20 17:46
|
显示全部楼层
zyouong 发表于 2015-11-18 14:32
ROW($D$1:$D$123),100),ROW(A1)是什么个意思。假如我现在遇到了更多的比对项目和更多的列该怎么修改公式。
=INDEX(Sheet1!A:A,SMALL(IF(ISERROR(MATCH(Sheet1!$A$1:$A$123&Sheet1!$B$1:$B$123&Sheet1!$C$1:$C$123&Sheet1!$D$1:$D$123&Sheet1!$E$1:$E$123&Sheet1!$F$1:$F$123&Sheet1!$G$1:$G$123,Sheet2!$A$1:$A$123&Sheet2!$B$1:$B$123&Sheet2!$C$1:$C$123&Sheet2!$D$1:$D$123&Sheet2!$E$1:$E$123&Sheet2!$F$1:$F$123&Sheet2!$G$1:$G$123)),ROW($D$1:$D$123),100),ROW(A1))) |
|