|
- Sub test()
- Set d = CreateObject("scripting.dictionary")
- arr = [e1:j6]
- brr = [e9:h20]
- On Error Resume Next
- For i = 1 To 6
- For j = 1 To 6
- If arr(i, j) = Cells(Rows.Count, 3).End(3) Then f = 1: Exit For
- Next
- If f = 1 Then Exit For
- Next
- For l = 1 To 6
- For m = 1 To 12
- For n = 2 To 4
- If brr(m, n) = arr(i, l) Then
- x = x + 1
- d.Add brr(m, 1), ""
- End If
- Next
- Next
- Next
- For l = 1 To 6
- For m = 1 To 12
- For n = 2 To 4
- If brr(m, n) = arr(l, j) Then
- x = x + 1
- d.Add brr(m, 1), ""
- End If
- Next
- Next
- Next
- [e25] = Join(d.keys, ",")
- End Sub
复制代码 瞎写的感觉好复杂 |
评分
-
查看全部评分
|