Forum Discussion
Solved
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 https://www.youtube.com/watch?v=QJ2O07EB80Q!
=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
you just might want to use this formula: =TEXTJOIN(" & ",TRUE,UNIQUE(F:F,FALSE,FALSE))
To improve performance using entire column I'd modify as
=TEXTJOIN(" & ",,UNIQUE( TOCOL( F:F,3)) )THIS!!! Simple, effective, winning!
