G2{=SUM(TEXT((MMULT({1,1,1,1},1-ISERR(FIND(MID(B2:E2,{1;2;3;4},1),B$1:E$1)>1))=4)*(B2:E2<>"")*5-(LEN(B$1:E$1)<>LEN(B2:E2))*3,"0;!0;0")*1)
另解{=SUM(IF(B2:E2=B$1:E$1,5,IF((MMULT({1,1,1,1},IFERROR(FIND(MID(B2:E2,{1;2;3;4},1),B$1:E$1),99))<10)*(B2:E2<>""),2)))
另解{=SUM((B2:E2=B$1:E$1)*3+2*(0=MMULT({1,1,1,1},-ISERR(FIND(MID(B2:E2,{1;2;3;4},1),B$1:E$1))))*(B2:E2<>""))
留言
張貼留言