|
本帖最后由 scl5801 于 2016-8-21 19:34 编辑
Sub gxgs()
Dim arr, i%, x%, y%, t$
Dim ar(1 To 33, 1 To 2)
For x = 1 To 33
ar(x, 1) = x
Next x
arr = Range("C10:J" & Range("C65536").End(xlUp).Row)
t = Range("P10")
For i = 1 To UBound(ar)
For x = 1 To UBound(arr)
If arr(x, 8) = t Then
For y = 1 To 6
If arr(x, y) <> ar(i, 1) Then
ar(i, 2) = ar(i, 2) + 0
Else
ar(i, 2) = ar(i, 2) + 1
End If
Next y
End If
Next x
Next i
Range("S10").Resize(UBound(ar)) = Application.Index(ar, 0, 2)
Erase arr
End Sub |
评分
-
查看全部评分
|