Forum Discussion
Removing duplicates when using TEXTJOIN
Hi, I am using TEXTJOIN to being into one cell entries from a separate column, where I am ignoring empty cells and separately by &. This works fine. However, I can have duplicate values in an indi...
Kristy,
I got the below formula for you thanks to this amazing video!
=TEXTJOIN(" & ",TRUE,IF(MATCH(A1:A6,A1:A6,0)=ROW(A1:A6)-ROW(A1)+1,A1:A6,""))Please find it in the attached file.
Regards
Kristy,
I got the below formula for you thanks to this amazing video!
=TEXTJOIN(" & ",TRUE,IF(MATCH(A1:A6,A1:A6,0)=ROW(A1:A6)-ROW(A1)+1,A1:A6,""))Please find it in the attached file.
Regards
Hi Haytham,
Thank you for your response.
However, I get a VALUE error in Excel:
=TEXTJOIN(" & ",TRUE,IF(MATCH('1'!$F$10:$F$606,0)=ROW('1'!$F$10:$F$606)-ROW('1'!$F$10)+1,'1'!$F$10:$F$606,""))
Is what I translated your formula in to.
Kirsty
