|
发表于 2013-7-12 21:34
|
显示全部楼层
本楼为最佳答案
Sub test()
Dim ar(), ar2()
ar = [a1:g125].Value
ReDim ar2(1 To UBound(ar), 1 To 1)
For i% = 1 To UBound(ar) Step 3
If k% <> ar(i + 1, 7) Then
If n% >= 6 Then
r = r% + 1
ar2(r, 1) = k
End If
n = 0
k% = ar(i + 1, 7)
str1$ = ar(i, 1) & "|" & ar(i, 2) & "|" & ar(i, 4) & "|" & ar(i, 5)
End If
If str1$ = ar(i, 1) & "|" & ar(i, 2) & "|" & ar(i, 4) & "|" & ar(i, 5) And str1$ = ar(i + 1, 1) & "|" & ar(i + 1, 2) & "|" & ar(i + 1, 4) & "|" & ar(i + 1, 5) And ar(i, 1) = ar(i, 4) And ar(i + 1, 1) = ar(i + 1, 4) Then
n = n + 1
Else
If n% >= 6 Then
r = r% + 1
ar2(r, 1) = k
End If
str1$ = ar(i, 1) & "|" & ar(i, 2) & "|" & ar(i, 4) & "|" & ar(i, 5)
n = 1
End If
Next
If n% >= 6 Then
r = r% + 1
ar2(r, 1) = k
End If
If r Then [q1].Resize(r, 1) = ar2
End Sub |
评分
-
查看全部评分
|