Text Join and FILTER with multiple criteria

[dhana_ram]

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!

 

[Fluff]

How about

=TEXTJOIN(", ",,FILTER($C$2:$C$13,($A$2:$A$13=F2)*($B$2:$B$13=G2),""))

 

[dhana_ram]

How about

=TEXTJOIN(", ",,FILTER($C$2:$C$13,($A$2:$A$13=F2)*($B$2:$B$13=G2),""))

Thanks for the help, it works!

So the "*" is like an "and" i suppose?

 

[Fluff]

That's right.

Glad to help & thanks for the feedback.