I am trying to create a formula that will identify all matching data in column A, where there is a match the data in column D should be returned in column E with each result seperated by " / ".
I have uploaded a spreadsheet with a sample of the ideal outcome. Where the ID in column A matches, the data in column D should be returned for all matches in column E with " / " as the seperator.
I have tried the formula =INDEX($D$2:$D$17,MATCH(A2,$A$2:$A$17,0)) but this only provides one match.
It can be done with a concatenation UDF. I think I borrowed this one from Mike Rickson.
ConcatIfs in Scotland.xlsm
The function and parameters: ConcatIf(criteria range,criteria,output range,delimiter in quotes)
So I used:
=CONCATIF($A$2:$A$17,A2,$D$2:$D$17," / ")
To get this, copy the code below, then in Excel hit Alt+F11, Insert Module, and paste the code, and close that window.
Call the User Defined Function as described above
Please Login or Register to view this content.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
This is exactly what i was looking for. Much appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks