|
发表于 2012-2-10 14:22
|
显示全部楼层
本楼为最佳答案
本帖最后由 liuts 于 2012-2-10 14:26 编辑
- Option Explicit
- Sub liuts()
- Dim arr, i%, j%, k%, icount%
- With Sheet1
- arr = .Range("d6:av11")
- k = 1
- For i = 1 To UBound(arr)
- For j = 2 To UBound(arr, 2)
- If CStr(arr(i, j)) = CStr(arr(i, j - 1)) And arr(i, j - 1) <> "" Then
- k = k + 1
- Else
- If k >= 3 Then icount = icount + k - 2
- k = 1
- End If
- Next j
- Next i
- .Range("d5") = icount
- End With
- End Sub
复制代码
Book2.rar
(8.33 KB, 下载次数: 10)
|
|