|
发表于 2013-6-19 15:44
|
显示全部楼层
本楼为最佳答案
- Sub tongjizu()
- Dim arr, arr1
- Dim d As Object, x, y
- Set d = CreateObject("scripting.dictionary")
- Set d1 = CreateObject("scripting.dictionary")
- arr = Range("b2:e21257")
- arr1 = Range("g2:g13")
- For x = 1 To 3
- For y = 1 To UBound(arr)
- If arr(y, 2) = arr1(x * 4 - 3, 1) Then
- If arr(y + 1, 2) = arr1(x * 4 - 2, 1) Then
- If arr(y + 2, 2) = arr1(x * 4 - 1, 1) Then
- If arr(y + 3, 2) = arr1(x * 4, 1) Then
- y = y + 3
- MsgBox y
- d(arr(y, 1)) = d(arr(y, 1)) + 1
- d1(arr(y, 4)) = d1(arr(y, 4)) + 1
- GoTo 100
- End If
- End If
- End If
- End If
- 100:
- Next y
- Next x
- Range("i2").Resize(d.Count) = Application.Transpose(d.keys)
- Range("j2").Resize(d.Count) = Application.Transpose(d.items)
- Range("L2").Resize(d1.Count) = Application.Transpose(d1.keys)
- Range("m2").Resize(d1.Count) = Application.Transpose(d1.items)
- End Sub
复制代码 |
|