JoinText formula that strings together a range of cells with a comma but ignores the value in that column that is the same row as the formula.

[MDBWebDev]

I have column A that has product URL handles. Column B, I need a formula that joins all cells in column A, delimiter is a comma, ignoring empties is TRUE, BUT I need it to ignore the row that the formula is currently in so B3's formula would skip A3 and B4 would skip A4.

Somethign like: TextJoin(",",TRUE, A2:A20, Except A column value in current row)

 

[Fluff]

Hi & welcome to MrExcel.
How about

=SUBSTITUTE(TEXTJOIN(",",, $A$2:$A$20),A2&",","")

 

[Herakles]

Also

=TEXTJOIN(",",TRUE,FILTER($A$2:$A$12,$A$2:$A$12 <> $A2))

 

[MDBWebDev]

Hi & welcome to MrExcel.
How about

=SUBSTITUTE(TEXTJOIN(",",, $A$2:$A$20),A2&",","")

This solution also worked great! It would only let me accept one solution. Thank you!

 

[MDBWebDev]

Also

=TEXTJOIN(",",TRUE,FILTER($A$2:$A$12,$A$2:$A$12 <> $A2))

This worked perfectly. Thank You!

 

[Fluff]

Glad we could help & thanks for the feedback.