How to extract only unique values from TEXTJOIN string?

[Jasuan]

Problem: Used textjoin to create tables based on an identifier. Textjoin has now created multiple stings of numbers (i.e. "7, 26" and "7, 37") and I can not figure out which function or combination of functions to use retain only the first unique instance of a number.

I have tried the following formula: =TEXTJOIN(", ",TRUE,IF(I2:I22<>"",IF(MATCH(I2:I22,I2:I22,0)=(ROW(I2:I22)-ROW(I1)),I2:I22,""),""))
However, this returns "7, 26, 7, 37, 7" When I only want "7, 26, 37"

 

[mali_cap]

You can use the sort function, like

=TEXTJOIN(", ",1,SORT(UNIQUE(FILTERXML("<p><c>"&SUBSTITUTE(TEXTJOIN(", ",1,I2:I22),",","</c><c>")&"</c></p>","//c"))))

Working..
Now THATS a formula!! never thought to insert "sort" in this manner.
Thank you for the great work you provide

 

[Fluff]

You're welcome & thanks for the feedback.