Text Join Unique Values but do not include a word

[VBA learner ITG]

hi all,

I was wondering if you could advise or point me in the right direction as I want to use the below formula.

However, if the word "False" appears it does not show it in the cell?

=TEXTJOIN(",",TRUE,UNIQUE(IF(K2:K36=BR2,N2:N36,"")))

 

[Fluff]

How about

=TEXTJOIN(",",TRUE,UNIQUE(FILTER(N2:N36,(K2:K36=BR2)*(N2:N36<>FALSE))))

 

[VBA learner ITG]

How about

=TEXTJOIN(",",TRUE,UNIQUE(FILTER(N2:N36,(K2:K36=BR2)*(N2:N36<>FALSE))))

Hi Fluff,

Thank you again for your help. I have learnt a new formula which will come in handy.

 

[Fluff]

Glad to help & thanks for the feedback.