Return unique values from list as a comma separated string

[dridlebert]

Hey folks,

how to get from a list with redundant values and a condition to a comma separated text string?

I was first playing with this formular =INDEX(list,MATCH(0,COUNTIF(uniques,list),0)) but couldnt transpose the result and nor convert into string.

In my example I want to consider only the values which meet the condition "New" from Coloum A.

Any thoughts on this challenge?

Kindly
idlebert

[CARACALLA]

D17=textjoin(",",,unique(filter(b3:b13,a3:a13=a3)))

[dridlebert]

Wonderful and efficient solution. Thanks!