Remove duplicate in string and/or concatenate words

See the attached screenshot for an idea of what I’m trying to accomplish. I’m using a formula to concatenate the names of sellers and buyers. Simple except that if there are two or more names, how can I remove the identical last name, or add an & between names if they are different names?

This can be done using a single rollup field. Roll up the last name based on the {Linked to Contacts}, and use this aggregation formula:

IF(values, "Seller to " & ARRAYJOIN(ARRAYUNIQUE(values), " & "))

Screen Shot 2021-09-05 at 9.03.36 AM

The ARRAYUNIQUE() function gets rid of duplicate last names, ARRAYJOIN() joins them with the ampersand, and the rest adds the prefix as long as there’s one incoming name.

Thank you so very much. This works perfectly.

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.