'限制:
'1)参数是一行区域
'2)各参数包含的元素个数相同
Function SameNumber(ParamArray A() As Variant)
Dim B, C, D, i, j
C = A(0): D = C
ReDim C(1 To 1, 1 To UBound(C, 2))
For i = 0 To UBound(A)
B = A(i)
For j = LBound(C, 2) To UBound(C, 2)
C(1, j) = IIf(i, C(1, j) = B(1, j), B(1, j))
Next j
Next i
For j = LBound(C, 2) To UBound(C, 2)
If C(1, j) Then SameNumber = SameNumber + 1
Next j
SameNumber = SameNumber & List(C, D)
End Function
'返回实际数字的列表
Function List(C, D) As String
Dim j
For j = LBound(C, 2) To UBound(C, 2)
If C(1, j) Then List = List & "," & D(1, j)
Next j
List = "(" & Mid(List, 2) & ")"
End Function
求相同5.rar
(11.03 KB, 下载次数: 14)