How my TEXTJOINT show blank when there is no values in cell source

[Zaimon]

My TEXTJOINT formula show 0 values even the cell source is empty

=(TEXTJOIN(", ",TRUE,IF($A$2:$A$136=C3,$B$2:$B$136,"")))

Is there anyway I can fix this? What I want to see is blank when the cell source is empty.

Thank you in advance,

 

[ExcelToDAX]

Not sure what you are trying to accomplish, but when you use $B$2:$B$136 that will return all 0's since it is blank. You can try this:

=(TEXTJOIN(", ",TRUE,IF($A$2:$A$136=C2,IF(ISBLANK($B$2:$B$136),"",$B$2:$B$136),"")))

 

[Fluff]

Hi & welcome to MrExcel.
How about

=TEXTJOIN(", ",TRUE,IF($A$2:$A$136=C3,$B$2:$B$136&"",""))

 

[Scott Huish]

I would use FILTER though
=TEXTJOIN(", ",TRUE,FILTER(B2:B136&"",A2:A136=C3,""))

 

[Zaimon]

Hi Guys, all your suggested formula works well.
Thank you so much for resolving my problem.

 

[Fluff]

Glad we could help & thanks for the feedback.