Exclude cell value from array when using textjoin

[ivanribic]

Okay, after working at this for several hours I'm still stumped. I'm using textjoin to display combined values from Col BF that match numbers in BH but I want to exclude the value in the current row. i.e. for row 2, I want to exclude "CP60" from the results in Col BI and display all other matches. I can't figure out how to filter that current row result out. Any help is greatly appreciated.

=ArrayFormula(TEXTJOIN(", ", TRUE, IF(BH2=$BH$2:$BH$346,$BF$2:$BF$346,"")))

 

[steve the fish]

Put another IF test in eg:

=TEXTJOIN(", ",TRUE,IF(BH2:BH10=BH2,IF(BF2:BF10<>BF2,BF2:BF10,""),""))

 

[ivanribic]

Steve, you saved my bacon. I had tried to do just that about a dozen times but wasn't laying it out correctly. That worked brilliantly. Thank you so much!