|
仅供参考。。。
- Sub ykcbf() '//2024.4.21
- Set d = CreateObject("Scripting.Dictionary")
- r = Cells(Rows.Count, 2).End(3).Row
- arr = [b5].Resize(r - 4, 6)
- r = Cells(Rows.Count, "n").End(3).Row
- brr = [j5].Resize(r - 4, 26)
- For i = 1 To UBound(arr)
- d.RemoveAll
- For j = 1 To UBound(arr, 2)
- s = arr(i, j)
- d(s) = ""
- Next
- For x = 1 To UBound(brr)
- If brr(x, 2) = 0 Then
- m = 0: n = 0: k = 0
- For j = 5 To 15
- s = brr(x, j)
- If d.exists(s) Then m = m + 1
- Next
- brr(x, 3) = m
- For j = 16 To UBound(brr, 2)
- s = brr(x, j)
- If d.exists(s) Then n = n + 1
- Next
- brr(x, 4) = n
- If m = n Then
- brr(x, 2) = 1
- Else
- k = k + 1
- brr(x, 1) = k
- End If
- End If
- Next
- Next
- [j5].Resize(r - 4, 26) = brr
- Set d = Nothing
- MsgBox "OK!"
- End Sub
复制代码
|
评分
-
1
查看全部评分
-
|