|
'사용자 정의 함수입니다.
'첨부 파일 참조바랍니다.
'-----------------------------------------------------------------------------------------------------
Function concatX(x As Range, y As Range, v As Range, sDelimiter As String) As String
'-----------------------------------------------------------------------------------------------------
Dim sTemp As String: sTemp = ""
Dim iX As Long: iX = x.Rows.Count
'Stop
Dim i As Long: i = 1
For Each Row In x.Rows
If Join(Application.Transpose(Application.Transpose(Row.Value))) = _
Join(Application.Transpose(Application.Transpose(y.Value))) Then
sTemp = sTemp & IIf(sTemp = "", "", sDelimiter) & v.Cells(i).Value
End If
i = i + 1
Next
concatX = sTemp
End Function
|
|