自定义函数,代码就在附件里 Function aa(x) Dim w(100) As Integer s = 0 For i = 1 To Len(x) - 2 For j = i To Len(x) Step 2 s = s + 1 w(s) = Val(Mid(x, j, 2)) Next j Next i p = 0 For i = 1 To s - 1 If w(i + 1) - w(i) = 1 Then p = p + 1 If w(i) - w(i + 1) = 1 Then p1 = p1 + 1 Next i If p > 3 Or p1 > 3 Then aa = "符合" Else aa = "" End Function
|