Forum Discussion

Kirsty Lowe's avatar
Kirsty Lowe
Copper Contributor
May 01, 2018
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...
Formulas & Functions
TEXTJOIN
  • Haytham Amairah's avatar
    Haytham Amairah
    May 01, 2018

    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

Kirsty Lowe's avatar
Kirsty Lowe
Copper Contributor
May 01, 2018

So sorry I got there in the end, with help from Haytham Amairah

I went back to the video you linked and used the following formula, remembering to use Ctrl+Shift+Enter to apply it, and this time it worked :)

{=TEXTJOIN(", ",,IF(F10:F50<>"",IF(MATCH(F10:F50,F10:F50,0)=(ROW(F10:F50)-ROW(F9)),F10:F50,""),""))}

Thank you!

 
 
 

Resources