EXCEL中如何找出多列数据中相同的项 |
您所在的位置:网站首页 › excel表格列太多,影响查看 › EXCEL中如何找出多列数据中相同的项 |
全是数组公式,公式输完后,光标放在公式编辑栏同时按下CTRL+SHIFT+回车键,使数组公式生效 G1=MIN(IF((COUNTIF(B$1:B$12,$A$1:$A$12)>0)*(COUNTIF(C$1:C$12,$A$1:$A$12)>0)*(COUNTIF(D$1:D$12,$A$1:$A$12)>0)*(COUNTIF(E$1:E$12,$A$1:$A$12)>0),$A$1:$A$12,4^8)) G2=IF(MIN(IF(IF((COUNTIF(B$1:B$12,$A$1:$A$12)>0)*(COUNTIF(C$1:C$12,$A$1:$A$12)>0)*(COUNTIF(D$1:D$12,$A$1:$A$12)>0)*(COUNTIF(E$1:E$12,$A$1:$A$12)>0),$A$1:$A$12,4^8)>G1,IF((COUNTIF(B$1:B$12,$A$1:$A$12)>0)*(COUNTIF(C$1:C$12,$A$1:$A$12)>0)*(COUNTIF(D$1:D$12,$A$1:$A$12)>0)*(COUNTIF(E$1:E$12,$A$1:$A$12)>0),$A$1:$A$12,4^8),4^8))=4^8,"",MIN(IF(IF((COUNTIF(B$1:B$12,$A$1:$A$12)>0)*(COUNTIF(C$1:C$12,$A$1:$A$12)>0)*(COUNTIF(D$1:D$12,$A$1:$A$12)>0)*(COUNTIF(E$1:E$12,$A$1:$A$12)>0),$A$1:$A$12,4^8)>G1,IF((COUNTIF(B$1:B$12,$A$1:$A$12)>0)*(COUNTIF(C$1:C$12,$A$1:$A$12)>0)*(COUNTIF(D$1:D$12,$A$1:$A$12)>0)*(COUNTIF(E$1:E$12,$A$1:$A$12)>0),$A$1:$A$12,4^8),4^8)))向下复制 |
今日新闻 |
推荐新闻 |
CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |