先排序数组Function Find(a, b) As Integer Dim i, j, m, n i = 0: j = 0: Find = 0 m = UBound(a): n = UBound(b) Do Until i > m Or j > n If a(i) < b(j) Then i = i + 1 ElseIf a(i) = b(j) Then Find = Find + 1: i = i + 1: j = j + 1 ElseIf a(i) > b(j) Then j = j + 1 End If Loop End Function
Dim i, j, m, n
i = 0: j = 0: Find = 0
m = UBound(a): n = UBound(b)
Do Until i > m Or j > n
If a(i) < b(j) Then
i = i + 1
ElseIf a(i) = b(j) Then
Find = Find + 1: i = i + 1: j = j + 1
ElseIf a(i) > b(j) Then
j = j + 1
End If
Loop
End Function