Forum Discussion
Solved
Textsplit passed to unique
Hi, I am trying to find unique values from a list where entries can consist of multiple values that are separated by slashes. The Textsplit function splits but omisses text after the first separator....
Simplest option is to join the strings first, prior to splitting:
=SORT(UNIQUE(TEXTSPLIT(TEXTJOIN("/", , D3:D4), , "/", TRUE, 0)))Regards
Simplest option is to join the strings first, prior to splitting:
=SORT(UNIQUE(TEXTSPLIT(TEXTJOIN("/", , D3:D4), , "/", TRUE, 0)))
Regards
Works like a charm! Thanks a lot! 🙂