|
楼主 |
发表于 2017-2-7 21:09
|
显示全部楼层
Sub TEST1()
Dim Arr, X, A%(1 To 33), N%, B(1 To 33), i%, j&, k%
For Each X In [J10:L10]
If X > 0 Then A(X) = 1: N = N + 1 '解释这句什么意思,A(X) = 1代表什么
Next '能不能用基本写法,重新写一次,看不懂这个
Arr = Range([C11], [C65536].End(3)(1, 6))
For j = 1 To UBound(Arr) - 1
X = 0
For k = 1 To 6
X = X + A(Arr(j, k))
Next
If X = N Then
For i = 1 To 6
B(Arr(j + 1, i)) = B(Arr(j + 1, i)) + 1
Next
End If
Next j
[J12].Resize(1, 33) = B
End Sub
|
|