去重出现了问题，帮忙看一下，谢谢各位

77942164 · 发表于 2023-7-7 19:22

本帖最后由 77942164 于 2023-7-7 19:24 编辑

=SUMPRODUCT(1/COUNTIFS(出库数据表2!$X$2:$X$1497,出库数据表2!$X$2:$X$1497,出库数据表2!$D$2:$D$1497,出库数据表2!$D$2:$D$1497,出库数据表2!$AI$2:$AI$1497,出库数据表2!$AI$2:$AI$1497,出库数据表2!$AJ$2:$AJ$1497,出库数据表2!$AJ$2:$AJ$1497,出库数据表2!$AR$2:$AR$1497,出库数据表2!$AR$2:$AR$1497)*(出库数据表2!$X$2:$X$1497="定期保养")*(出库数据表2!$AI$2:$AI$1497=$A4)*(ISNUMBER(FIND({"0889280100","088GM118E1","088GM118E2","088GM118F1","088GM118F2","088GM158F0","088GM208A2","088GM218B2","088GM218B3","088GM218B5","088GM228A4","088GM228E4","088GM228S1","4011","4021","57701","GTMC0CX004","GTMC0CX006","GTMC0CX019","QYCTQX-TY","RSSYJCTJ-TY","SYCHQX-TY","YMQCJ-TB","ZC001WHJ"},出库数据表2!$D$2:$D$1497)))*(出库数据表2!$AJ$2:$AJ$1497=$A$2))

77942164 · 发表于 2023-7-7 19:26

台次得数应该是3台，公式得出的是6，麻烦帮忙修改一下

77942164 · 发表于 2023-7-8 14:02

没有大神能帮忙解决一下吗，呜呜

yfan17 · 发表于 2023-7-8 14:09

https://club.excelhome.net/threa ... tml?_dsign=bc98cbe9

橒♂蝣 · 发表于 2023-7-8 14:22

建议上传个附件哈，这样不清楚

rocklyman · 发表于 2023-7-8 15:20

这么长的公式你就不怕EXCEL卡死

1007890405 · 发表于 2023-7-10 13:47

完了，阅读恐惧症犯了，这公式太长了

		自动登录	找回密码
密码			免费注册

[求助] 去重出现了问题，帮忙看一下，谢谢各位