201612181655連續三天签到有幾人 (2835)

C2:C21{=IF((SUM(IF(ISNA(MATCH(A2&B2+{0,1,2},A$2:A$21&B$2:B$21,)),,1))=3)*(SUMIF(A$1:A1,A2,C$1:C1)=0),1,"")

E2=SUM(C:C)

F2{=COUNT(0/(MATCH(A2:A21,IF(MMULT(IF(ISNA(MATCH(A2:A21&B2:B21+{0,1,2},A$2:A$21&B$2:B$21,)),,1),{1;1;1})=3,A2:A21),)=ROW(1:20)))

回應
關鍵字
    沒有新回應!
    blank





Powered by Xuite