Filter Distinct Values Only

[nburaq]

Hi All,
I have created a formula that filters the data with multiple criteria and then textjoins all values in a cell. However I cant figure out how to sort distinct values. I know how to list Unique values but not other way around. I will be glad if someone can modify my formula. Thanks again for your help!

=TEXTJOIN(", ";TRUE;FILTER(Data!$AE$2:$AE$40619;(Data!$D$2:$D$40619=$D2)*(Data!$K$2:$K$40619="CRTD");"Not Available"))

 

[Fluff]

What exactly do you mean by

I cant figure out how to sort distinct values

 

[nburaq]

What exactly do you mean by

my formula gives the result even if there are repeating values like ( 10,11,12,18,22,11,33,12) but I need repeating values only once. It is not important for me if filter function returns all repeating values.

Ok I think I just need to UNIQUE to just before FILTER function. Thanks again

 

[Fluff]

I think I just need to UNIQUE to just before FILTER function

Did you try that?

 

[nburaq]

Did you try that?

Yes, and it works. Thanks again !

 

[Fluff]

Glad you sorted it & thanks for the feedback.