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
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