kandhong 发表于 2015-1-13 13:49
芐雨老师:
您的VBA已收悉,效果非常好!!
此外,还有一事请教:能否让L列每位数都和K列所 ...
修改一下里面的代码即可,还有对比的顺序是从上而下- Sub t()
- Dim arr, brr, crr, i&, j&, x%
- arr = Range("K4:L" & Cells(Rows.Count, "K").End(3).Row)
- ReDim brr(0 To 99)
- ReDim crr(1 To UBound(arr), 1 To UBound(arr))
- For i = 1 To UBound(arr)
- brr(Val(Mid(arr(i, 2), 1, 2))) = 1
- brr(Val(Mid(arr(i, 2), 3, 2))) = 1
- brr(Val(Mid(arr(i, 2), 5, 2))) = 1
- For j = 1 To UBound(arr)
- For x = 1 To 6 Step 2
- If brr(Val(Mid(arr(j, 1), x, 2))) = 1 Then
- crr(i, j) = 1
- Exit For
- Else
- crr(i, j) = 2
- End If
- Next
- Next
- ReDim brr(0 To 99)
- Next
- Range("M4").Resize(UBound(arr), UBound(arr)) = crr
- End Sub
复制代码 |