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
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
Hi,
I have also tried by watching the video and placing the formula into my sheet so I didn't have to reference a different worksheet, and it still fails to evaluate the data.
=TEXTJOIN(", ",,IF(MATCH(F10:F50,F10:F50,0)=(ROW(F10:F50)-ROW(F9)),F10:F50,""))
Sorry!
Kirsty
I have also tried by watching the video and placing the formula into my sheet so I didn't have to reference a different worksheet, and it still fails to evaluate the data.
=TEXTJOIN(", ",,IF(MATCH(F10:F50,F10:F50,0)=(ROW(F10:F50)-ROW(F9)),F10:F50,""))
Sorry!
Kirsty