|
用VBA很好解决。- Sub tt()
- Dim X&
- arr = Range("d6:m" & [d65536].End(3).Row)
- Set d = CreateObject("scripting.dictionary")
- ReDim brr(1 To UBound(arr), 1 To 1)
- X = [N4] '上X行
- For k = 1 + X To UBound(brr)
- For i = k - X To k - 1 '上X行
- For j = 1 To 9 '各列
- a = Val(arr(i, j) & arr(i, j + 1)) '二连号
- d(a) = d(a) + 1 '相同二连号,计数+1
- Next
- Next
- For Each a In d.keys '计数大于1的二连号,总计数+1
- If d(a) > 1 Then brr(k, 1) = brr(k, 1) + 1
- Next
- d.RemoveAll
- Next
- [N6].Resize(UBound(arr), 1) = brr
- End Sub
复制代码 |
|