|
Excel高手用VBA解决最大连续数字次数再改一下
- Sub Macro1()
- Dim arr, d, i&
- Set d = CreateObject("scripting.dictionary")
- arr = Range("e5:e" & Range("e65536").End(xlUp).Row + 1)
- n = 1
- For i = 2 To UBound(arr)
- If arr(i, 1) = arr(i - 1, 1) Then
- n = n + 1
- Else
- If Not d.exists(arr(i - 1, 1)) Then
- d(arr(i - 1, 1)) = n
- Else
- If n > d(arr(i - 1, 1)) Then d(arr(i - 1, 1)) = n
- End If
- n = 1
- End If
- Next
- [h20] = d([f20].Value)
- End Sub
复制代码
|
|