|
发表于 2015-7-21 08:54
|
显示全部楼层
本楼为最佳答案
Sub Click()
Dim A, B, C, i, j, k
A = Range("A4").CurrentRegion
B = Range("L1").CurrentRegion
ReDim C(1 To UBound(A), 1 To UBound(B, 2))
For i = 2 To UBound(C)
For j = 1 To UBound(C, 2)
C(i, j) = C(i - 1, j) + 1
For k = 1 To UBound(A, 2)
If A(i, k) = B(1, j) Then C(i, j) = 0: Exit For
Next k
Next j
Next i
[L4].Resize(i - 1, j - 1) = C
End Sub
3.rar
(75.18 KB, 下载次数: 13)
|
|