请老师帮忙；排与排相等数谢谢！

909459520 · 发表于 2023-6-22 22:05

请老师帮忙；排与排相等数谢谢！

solextrade · 发表于 2023-6-23 08:30

B7 =TEXT(COUNTIFS(D:D,D7,F:F,F7,H:H,H7,J:J,J7),"[>1]0;;")
C7 =TEXT(MAX(MMULT({1,1,1,1},COUNTIF(OFFSET(D7,,{0,2,4,6}),N(OFFSET(D7,,{0;2;4;6}))))),"[>1]0;;")

tchh666 · 发表于 2023-6-23 08:35

=IF(D7,TEXT(5-COUNT(MATCH(ROW($1:$10)-1,N(OFFSET(D7,,{0,2,4,6})),)),"[>1];"),"")

=IF(D7,TEXT(SUM(N(MMULT(N(D$7:J$32=D7:J7),ROW(1:7)^0)=7)),"[>1];"),"")

复制代码

909459520 · 发表于 2023-6-28 20:54

tchh666 发表于 2023-6-23 08:35
=IF(D7,TEXT(5-COUNT(MATCH(ROW($1:$10)-1,N(OFFSET(D7,,{0,2,4,6})),)),"[>1];"),"")

醉清风麻烦在看看统计还是有点问题

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

[已解决] 请老师帮忙；排与排相等数谢谢！

评分

评分