|
发表于 2014-2-1 12:04
|
显示全部楼层
本楼为最佳答案
- Sub test()
- Dim arr(), brr(), crr(), i&, j%
- arr = Range("A4").CurrentRegion.Value
- brr = Range("C2").CurrentRegion.Value
- ReDim crr(1 To UBound(arr) + 1, 1 To UBound(brr, 2))
- For i = 1 To UBound(crr) - 1
- For j = 1 To UBound(crr, 2)
- crr(i + 1, j) = IIf(arr(i, 1) = brr(1, j), 0, crr(i, j) + 1)
- Next
- Next
- Range("C3").Resize(UBound(crr), UBound(crr, 2)) = crr
- End Sub
复制代码 请测试下,看看 |
|