Forum Discussion
textjoin issues
I would like to list the unique values for each row as an output, separated by a comma Example Consider cells A2=b B2=b C2=d I use the below formula and get cell D2 b,d Duplicates are re...
vishu1204 , that's as
=TEXTJOIN(",",TRUE,IF(B2:D2<>"",IF(COLUMN(B2:D2)+1-COLUMN(B2)=MATCH(B2:D2,B2:D2,0),B2:D2,""),""))