Text Join - Return Unique Text Only

%3CLINGO-SUB%20id%3D%22lingo-sub-2901115%22%20slang%3D%22en-US%22%3EText%20Join%20-%20Return%20Unique%20Text%20Only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2901115%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20trying%20to%20use%20text%20join%20with%20Unique%20function%20and%20it%20does%20not%20seem%20to%20be%20working%20for%20text.%20I%20have%20successfully%20used%20it%20for%20values%20in%20the%20same%20spreadsheet%20but%20can't%20seem%20to%20eliminate%20the%20duplicate%20words.%20Does%20the%20Unique%20function%20only%20work%20for%20values%20in%20O365%3F%20Or%20what%20could%20I%20be%20doing%20wrong%3F%20Thank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2901115%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2901187%22%20slang%3D%22en-US%22%3ERe%3A%20Text%20Join%20-%20Return%20Unique%20Text%20Only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2901187%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1200014%22%20target%3D%22_blank%22%3E%40WMonty223%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20seems%20to%20work%20in%20Excel%20online.%20Therefore%20it%20should%20work%20in%20Excel365%20as%20well%20in%20my%20understanding.%3C%2FP%3E%3CP%3E%3CSPAN%3E%3DTEXTJOIN(%2C%2CUNIQUE(B4%3AB7))%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2901287%22%20slang%3D%22en-US%22%3ERe%3A%20Text%20Join%20-%20Return%20Unique%20Text%20Only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2901287%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1200014%22%20target%3D%22_blank%22%3E%40WMonty223%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20seems%20to%20work%20in%20Excel%20online.%20Therefore%20it%20should%20work%20in%20Excel365%20as%20well%20in%20my%20understanding.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3DTEXTJOIN(%2C%2CUNIQUE(B4%3AB7))%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2901320%22%20slang%3D%22en-US%22%3ERe%3A%20Text%20Join%20-%20Return%20Unique%20Text%20Only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2901320%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1200014%22%20target%3D%22_blank%22%3E%40WMonty223%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20seems%20to%20work%20in%20Excel%20online.%20Therefore%20it%20should%20work%20in%20Excel365%20as%20well%20in%20my%20understanding.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3DTEXTJOIN(%2C%2CUNIQUE(B4%3AB7))%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi, I am trying to use text join with Unique function and it does not seem to be working for text. I have successfully used it for values in the same spreadsheet but can't seem to eliminate the duplicate words. Does the Unique function only work for values in O365? Or what could I be doing wrong? Thank you

3 Replies

@WMonty223 

It seems to work in Excel online. Therefore it should work in Excel365 as well in my understanding.

 

=TEXTJOIN(,,UNIQUE(B4:B7))

@WMonty223 

UNIQUE works with text fields in 365 but perhaps not in the manner you require.

image.png

Records are only eliminated only if they duplicate another record in its entirety.  

I am not sure what you are planning to do with TEXTJOIN.

@WMonty223 

Better with sample, at least it's not clear unique or distinct (third parameter) values are to be joined.