Help Looking up within a data range and if not blank joining

[rrickard]

I have a list of Jobs in Column B. If the job has a deduction (any value in column C), then we want the Jobs to be joined together in one cell.

See below where column B and C are the dataset. We want the joined list of Jobs in one single cell.

Note that Column A is missing below. Row 1 is also missing below.

Job (B)	Deduction (C)	Wrong/Current Result	Desired Result
123	1	123,456,578,584,364	123,578,364
456
578	2	123,456,578,584,364
584
364	5	123,456,578,584,364

Wrong/Current Formula is =IF(C3<>"",TEXTJOIN(",",,$B$3,$B$4,$B$5,$B$6,$B$7)," "), but I need it to look at C3 through C7, then join column B where C isn't blank.

 

[Scott T]

Does this do what you want?
=IF(C3<>"",TEXTJOIN(",",TRUE,IF($C$3:$C$7<>"",$B$3:$B$7,"")),"")

 

[rrickard]

Does this do what you want?
=IF(C3<>"",TEXTJOIN(",",TRUE,IF($C$3:$C$7<>"",$B$3:$B$7,"")),"")

Almost! It works unless C3 is blank. So if I add data to the blank cells and delete C3 then there's no result at all.

Job	Deduction	Wrong Result	New Formula with C3
123	1	123,456,578,584,364	123,456,578,584,364
456	1	123,456,578,584,364
578	1	123,456,578,584,364
584	1	123,456,578,584,364
364	1	123,456,578,584,364

when I remove C3 it goes away

Job	Deduction	Wrong Result	New Formula with C3 removed
123
456	1	123,456,578,584,364
578	1	123,456,578,584,364
584	1	123,456,578,584,364
364	1	123,456,578,584,364

 

[Scott T]

Try
=IF(C3:C7<>"",TEXTJOIN(",",TRUE,IF($C$3:$C$7<>"",$B$3:$B$7,"")),"")

 

[rrickard]

Yeap! That's it! Thanks Scott!