回答編集履歴
1
正規表現の一部に誤りがあったので修正
test
CHANGED
|
@@ -50,7 +50,7 @@
|
|
|
50
50
|
|
|
51
51
|
```
|
|
52
52
|
|
|
53
|
-
=LEN(REGEXREPLACE(REGEXREPLACE(JOIN(,ARRAYFORMULA(E3:E70+G3:G70)),"111+[0
|
|
53
|
+
=LEN(REGEXREPLACE(REGEXREPLACE(JOIN(,ARRAYFORMULA(E3:E70+G3:G70)),"111+[02]","A"),"\d",))
|
|
54
54
|
|
|
55
55
|
```
|
|
56
56
|
|
|
@@ -72,7 +72,7 @@
|
|
|
72
72
|
|
|
73
73
|
```
|
|
74
74
|
|
|
75
|
-
=LEN(REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(JOIN(,ARRAYFORMULA(E3:E70+G3:G70)),"1111[0
|
|
75
|
+
=LEN(REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(JOIN(,ARRAYFORMULA(E3:E70+G3:G70)),"1111[01][02]","A"),"1+A",),"\d",))
|
|
76
76
|
|
|
77
77
|
```
|
|
78
78
|
|