|
- Sub test()
- Dim arr, brr, arrR(), dic As Object, i%, j%, irow%
- brr = Range("R3:EG3").Value
- irow = Cells(Rows.Count, "e").End(3).Row
- arr = Range("e9:p" & irow).Value
- ReDim arrR(1 To UBound(arr), 1 To 1)
- Set dic = CreateObject("scripting.dictionary")
- For i = 1 To UBound(brr, 2)
- dic(brr(1, i)) = ""
- Next i
- For i = 1 To UBound(arr)
- For j = 1 To UBound(arr, 2)
- If dic.exists(arr(i, j)) Then
- arrR(i, 1) = arrR(i, 1) + 1
- End If
- Next j
- Next i
- Range("q9").Resize(UBound(arr), 1) = arrR
- End Sub
复制代码 |
|