|
参与一下。。。
- Sub ykcbf() '//2024.4.21
- Set d = CreateObject("Scripting.Dictionary")
- arr = [b5:g7]
- brr = [j5:ai7]
- For i = 1 To UBound(arr)
- d.RemoveAll
- For j = 1 To UBound(arr, 2)
- s = arr(i, j)
- d(s) = ""
- Next
- m = 0: n = 0
- For j = 5 To 15
- s = brr(i, j)
- If d.exists(s) Then m = m + 1
- Next
- brr(i, 3) = m
- For j = 16 To UBound(brr, 2)
- s = brr(i, j)
- If d.exists(s) Then n = n + 1
- Next
- brr(i, 4) = n
- If m = n Then
- brr(i, 1) = 0: brr(i, 2) = 1
- Else
- brr(i, 1) = 1: brr(i, 2) = 0
- End If
- Next
- [j5:ai7] = brr
- Set d = Nothing
- MsgBox "OK!"
- End Sub
复制代码
|
评分
-
2
查看全部评分
-
|