TEXTJOIN function

Question

I am using the textjoin function to create a list of objects that meet 1 given criteria. I am getting a #name? error message.  I have made sure that the data that i am using is formatted as :general".  what next?  Here is my formula:  

{=textjoin(", ",1,REPT($A$2:$A$6651,(N2:N6651=$A6660)+0))}

What i am asking in this formula is:  look at the values in column "n" that match the value in cell A6660, and return a list of values from column "A".

Thank you.

Patty

Answer 1

Hi,

Looks like that formula is not supported in your version of MS Excel.  When you start tying =TEXTJOIN(, do you see the tool tips?

I am using Office 2016.  It should be a supported function.

Answer 2

Hi.  It worked for me.

Just want to say that the use of REPT here is very clever.

I've never seen that technique, so thank you for sharing.

Pretty neat.   :>)

Just learning it myself. :)

Answer 3

Hi.  It worked for me.

Just want to say that the use of REPT here is very clever.

I've never seen that technique, so thank you for sharing.

Pretty neat.   :>)

Answer 4

Hi,

Looks like that formula is not supported in your version of MS Excel.  When you start tying =TEXTJOIN(, do you see the tool tips?

Answer 5

I have also tried :

{=textjoin(", ",1,IF(N2:N6651=A6661,A2:A6651,""))}