|
- Sub cout()
- Dim i, j, x, k As Integer
- Dim dic
- Dim rng As Range
- Dim arr, arr1
- Set dic = CreateObject("scripting.dictionary")
- arr = Range("K4:S" & [k10000].End(xlUp).Row)
- For Each rng In Range("b2:d2")
- If Len(rng.Value) <> 0 Then dic(rng.Value) = ""
- Next
- arr1 = dic.keys
- Columns("j:j").ClearContents
- For i = 1 To UBound(arr)
- For j = 1 To UBound(arr, 2)
- For x = 0 To UBound(arr1)
- If arr(i, j) = arr1(x) Then k = k + 1
- Next
- Next
- Range("j" & i + 3) = k
- k = 0
- Next
- End Sub
复制代码
|
|