Forum Discussion

saravana0306's avatar
saravana0306
Copper Contributor
Jun 27, 2019

textjoin issues

Hello Everyone ,    I have the text join formula to combine a series of text in a row.  But the cells have a vlookup formula to get data from another sheet. When try to join the text resulted in t...
excel
Formulas and Functions
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Jun 27, 2019

saravana0306 

My guess would be:

=TEXTJOIN(" | ";TRUE;IF(COLUMN(F4:Y4)-COLUMN($F4)+1=MATCH(F4:Y4;F4:Y4;0);F4:Y4;""))

 

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jun 27, 2019

    I'd wrap by IFERROR

    =TEXTJOIN(" | ",TRUE,IFERROR(IF(COLUMN(F4:Y4)-COLUMN($F4)+1=MATCH(F4:Y4,F4:Y4,0),F4:Y4,""),""))

     

  • saravana0306's avatar
    saravana0306
    Copper Contributor
    Jun 27, 2019

    Detlef_Lewin 

     

    Thanks much for the time . Unfortunately, this one does not work as well. 

     

    Do you think it is because the there is some formula already there in the cell ?

Resources