TEXTJOIN only thw name/words ones

[thoart]

Hi

I was wondering if there is possible to make a TEXTJOIN formula to only pick up the name one time? Ex; A1=Mark A2=Robert A3=Robert. Then the cell with the TEXTJOIN formula should only have Mark, Robert. I have made this formula but need help with my problem =TEXTJOIN(",",TRUE,O76:O81)

 

[Joe4]

TEXTJOIN does not have anything in it that allows you to check for duplicates.
You would either need to remove the duplicates first, come up with some other formula, or create your own process to do it using VBA.

 

[pgc01]

Hi

Try this array formula:

=TEXTJOIN(",",TRUE,IFERROR(IF(MATCH(A1:A10,A1:A10,0)=ROW(A1:A10)-ROW(A1)+1,A1:A10,""),""))

This is an array formula, you have to confirm it with CTRL-SHIFT-ENTER and not just ENTER.

 

[thoart]

Thanks, it worked perfectly

 

[pgc01]

You're welcome.