Hello, I'm trying to concatenate unique values in a column which meet a certain criterion. I basically need to concatenate all the responsible persons for a given company without duplicates, as seen in column C of the attached screenshot. I'm using TEXTJOIN to get values which meet my criterion but don't know how to eliminate duplicates. Any ideas? Thanks in advance!
one option, perhaps:
Formula:
Please Login or Register to view this content.
You could use Power Query. Format the data in A:B as a table, then use:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
or, to assemble unique companies, in E2, copied down:
=IFERROR(INDEX($A$2:$A$12,MATCH(0,INDEX(COUNTIF($E$1:$E1,$A$2:$A$12),0),0)),"")
and then TEXTJOIN, in F2, copied down:
=TEXTJOIN(", ",,IF($A$2:$A$12=E2,$B$2:$B$12,""))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Wow, that worked like a charm. Thanks! I'm not familiar with the REPT function, but I will study your work to understand this in depth. Amazing work. Thanks again!
Thank you all for your responses. It's interesting to see different approaches to the same problem. I will give them a look to ensure I get the concept.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks