EXCEL中如何找出多列数据中相同的项

您所在的位置:网站首页 excel表格列太多,影响查看 EXCEL中如何找出多列数据中相同的项

EXCEL中如何找出多列数据中相同的项

#EXCEL中如何找出多列数据中相同的项| 来源: 网络整理| 查看: 265

 

全是数组公式,公式输完后,光标放在公式编辑栏同时按下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