- Sub tt()
- arr = [a1:e83]
- xstr = "奇偶奇偶"
- x = [c84]
- For i = 1 To UBound(arr) - 1
- If arr(i, 5) = "3,4" And arr(i + 1, 5) = "1,2" Then
- If arr(i, 3) = arr(i + 1, 3) Then sx = sx + 1 Else nx = nx + 1 '顺行数,逆行数
- End If
- Next
- p = InStr(xstr, x)
- [c85] = IIf(sx > nx, Mid(xstr, p + 2, 1), Mid(xstr, p + 1, 1)) '输出
- End Sub
复制代码 |