想实现断号的效果，麻烦老师们帮忙看看！

hunshimowang

在C列公式的基础上能否修改一下公式，实现每天当中有一两个断号，断号逻辑是随机，就像D列那样的效果，详见附件。希望各位老师不吝赐教！

hcm19522

E2{=IF(A1<>A2,1,IF(A2<>A3,2+SUM((A$2:A$92=A2)/COUNTIFS(A$2:A$92,A$2:A$92,B$2:B$92,B$2:B$92)),IF(B2=B1,E1,RANDBETWEEN(E1+1,ROUND(SUM((A$2:A2=A2)/COUNTIFS(A$2:A2,A$2:A2,B$2:B2,B$2:B2)),)+2))))

hunshimowang

hcm19522 发表于 2022-8-4 19:56
E2{=IF(A1A2,1,IF(A2A3,2+SUM((A$2:A$92=A2)/COUNTIFS(A$2:A$92,A$2:A$92,B$2:B$92,B$2:B$92)),IF(B2=B1,E1 ...