请教大师：excel如何统计符合条件的项连续出现的次数？

wd007

请教大师：excel如何统计次数？20匿名网友分类：软件被浏览28次4小时前

[url=]删除[/url]

wd007

补充一点，黑框1对应的黑圆是几个相连，向上就看几个相连的的。也就是说，黑框234和黑框1对应的黑圆数目是相等的。

wd007

求助各位大师，本人愿意出300元现金酬谢符合标准的函数公式。QQ2912904569

wd007

我提的问题难道都没有人会吗？

hcm19522

C2:C29{=IF((B2="●")*(B1="○")*AND(MMULT((FREQUENCY(IF(B2:B$30="●",ROW(B2:B$30)),IF(B2:B$30="○",ROW(B2:B$30)))={0,2})*1,{1;1})=1),1,)

D2=SUM(C:C)

D6{=COUNT(0/(ROW(INDIRECT("1:"&COUNT(FREQUENCY(IF(B2:B30="●",ROW(B2:B30)),IF(B2:B30<>"●",ROW(B2:B30))))))>MAX(((FREQUENCY(IF(B2:B30="●",ROW(B2:B30)),IF(B2:B30<>"●",ROW(B2:B30)))>0)*(FREQUENCY(IF(B2:B30="●",ROW(B2:B30)),IF(B2:B30<>"●",ROW(B2:B30)))<>2)>0)*(ROW(INDIRECT("1:"&COUNT(FREQUENCY(IF(B2:B30="●",ROW(B2:B30)),IF(B2:B30<>"●",ROW(B2:B30)))))))))/(FREQUENCY(IF(B2:B30="●",ROW(B2:B30)),IF(B2:B30<>"●",ROW(B2:B30)))=2))

wd007

hcm19522 发表于 2018-4-6 15:28
C2:C29{=IF((B2="●")*(B1="○")*AND(MMULT((FREQUENCY(IF(B2:B$30="●",ROW(B2:B$30)),IF(B2:B$30="○",RO ...

你好大师，我的权限发不了短消息只好回复你。虽然与我要求的条件有点出入，但经过我的修改加工，可以用了。谢谢大师！请加我微信号码  wd13782155538   我把现金转给你