Sub try()
arr = [C6:H6]
arr1 = [C10:H15]
ReDim brr(1 To UBound(arr1), 1 To 1)
s = UBound(arr, 2)
For i = 1 To UBound(arr, 2)
For j = 1 To UBound(arr1)
For n = 1 To UBound(arr1, 2)
If arr(1, i) = arr1(j, n) Then
brr(j, 1) = brr(j, 1) + 1
End If
Next
Next
Next
Sheet1.Range("i10").Resize(UBound(arr1), 1) = brr
End Sub
Sub try()
arr = [C6:H7]
s = UBound(arr, 2)........................................................这句是否多余删除,也可运行啊
For i = 1 To UBound(arr, 2)
For j = 1 To UBound(arr, 2)
If arr(1, i) = arr(2, j) Then
p = p + 1
Exit For
End If
Next
Next
[I5] = p
End Sub