Forum Discussion

ztimothy's avatar
ztimothy
Copper Contributor
May 01, 2020
Solved

Texjoin to remove duplicates

Hello,    Attached file I'm having issues with.   I have a column with list of units that includes duplicates. Next to that column is a list of Ages with more duplicates. For example, for said un...
  • Patrick2788's avatar
    May 01, 2020

    ztimothy 

    If you have 365:

     

    =TEXTJOIN(",",TRUE,SORT(UNIQUE(FILTER(B:B,A:A=F2)),1,1))

Resources