- Function jj(r, rng As Range)
- Application.Volatile
- Dim arr, iRow%, iCol%, i%, iStr$
- iRow = rng.End(xlDown).Row
- iCol = rng.Columns.Count
- arr = rng.Resize(iRow, iCol)
- For i = LBound(arr, 1) To UBound(arr, 1)
- If arr(i, 1) = r Then
- iStr = iStr & "、" & arr(i, 2)
- End If
- Next
- jj = Right(iStr, Len(iStr) - 1)
- End Function
复制代码 |