|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
下半部分数据处理。
- Sub ykcbf2() '//2024.4.21
- Set d = CreateObject("Scripting.Dictionary")
- arr = [b9:g11]
- brr = [j9:ai11]
- For j = 1 To UBound(arr, 2)
- s = arr(1, j)
- d(s) = ""
- Next
- For i = 1 To UBound(brr)
- 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
- [j9:ai11] = brr
- Set d = Nothing
- MsgBox "OK!"
- End Sub
复制代码
|
评分
-
1
查看全部评分
-
|