• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

CreatE A Unique Delimited String From a Delimited String – Excel Formula Method (by David Hager)

Lori

Active Member
Given a solution has already been provided, is this a challenge to find other solutions? If so, a possible formula for unique alphanumeric delimited values (with Ctrl+Shift+Enter):

=TEXTJOIN(",",,FILTERXML("<x><a>"&SUBSTITUTE(A1,",","</a><a>")&"</a></x>","//a[not(. = preceding::a/.)]"))
 

David Hager

New Member
Given a solution has already been provided, is this a challenge to find other solutions? If so, a possible formula for unique alphanumeric delimited values (with Ctrl+Shift+Enter):

=TEXTJOIN(",",,FILTERXML("<x><a>"&SUBSTITUTE(A1,",","</a><a>")&"</a></x>","//a[not(. = preceding::a/.)]"))
Looks great, Lori. Thanks! Now I have to figure out how this works :)
 
Top