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.
I want the output
a
b
| List | Sort/Unique/Textsplit for the array = SORT( UNIQUE( TEXTSPLIT( D3:D4, "/",,TRUE,0))) | Textsplit for each row | |||
| a | a | a | |||
| a/b | a | b |
How can I get there?
Thanks for your help.
Simplest option is to join the strings first, prior to splitting:
=SORT(UNIQUE(TEXTSPLIT(TEXTJOIN("/", , D3:D4), , "/", TRUE, 0)))Regards
3 Replies
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! 🙂
