Forum Discussion
Text Join - Return Unique Text Only
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 dupli...
UNIQUE works with text fields in 365 but perhaps not in the manner you require.
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.