Remove duplicates of Filter function output.

[nmmounir]

Hello Everyone,

I came across a challenge where I am using the filter function along with Textjoin function. The results is 100,100,100, 200. There are three 100's so the ideal answer should be 100, 200. I would like to remove the repeated numbers. how to do this?

here is the formula I used in column E
=TEXTJOIN(",",TRUE,FILTER($B$2:$B$8,$A$2:$A$8=D2))

i didn't use any formula in the ideal answer in column G. I just wrote the ideal answer manually.

Any help is much appreciated

 

[Fluff]

How about

=TEXTJOIN(",",TRUE,unique(FILTER($B$2:$B$8,$A$2:$A$8=D2)))