Hi All,
I need help to find the right way to combine "Text Join" and "Filter" function but with multiple criteria:
I have tried the text join and filter function combine but only with one criteria =TEXTJOIN(", ",,FILTER($C$2:$C$13,$A$2:$A$13=F2,"")) and the result was "Text 1, Text 2, Text 3, Text 4, Text 5, Text 6"
Here is the example data:
Column A - C
And here is the result I need:
Column F - H
Please help..
Thank you!
I need help to find the right way to combine "Text Join" and "Filter" function but with multiple criteria:
I have tried the text join and filter function combine but only with one criteria =TEXTJOIN(", ",,FILTER($C$2:$C$13,$A$2:$A$13=F2,"")) and the result was "Text 1, Text 2, Text 3, Text 4, Text 5, Text 6"
Here is the example data:
Column A - C
And here is the result I need:
Column F - H
Please help..
Thank you!