Forum Discussion
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...
My guess would be:
=TEXTJOIN(" | ";TRUE;IF(COLUMN(F4:Y4)-COLUMN($F4)+1=MATCH(F4:Y4;F4:Y4;0);F4:Y4;""))
I'd wrap by IFERROR
=TEXTJOIN(" | ",TRUE,IFERROR(IF(COLUMN(F4:Y4)-COLUMN($F4)+1=MATCH(F4:Y4,F4:Y4,0),F4:Y4,""),""))