TEXTJOIN to concatenate duplicates

[ajboots]

I swear this worked for me previously. I’d like the value of column-B concatenated, delimited if the value in column-A is a duplicate identified by conditional formatting. Thoughts?

=TEXTJOIN(“,”,TRUE,FILTER(B:B,A:A=A19,””))View attachment 114936

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Shouldn't the formula in C2 be looking at A2 rather than A19

 

[ajboots]

Corrected visual

 

[ajboots]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Shouldn't the formula in C2 be looking at A2 rather than A19

So, simple! Doh! Thank you for the catch - now it works

 

[Fluff]

You're welcome & thanks for the feedback.