Mar 30 2023 06:20 AM - edited Mar 30 2023 06:28 AM
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.
Mar 30 2023 06:44 AM
Solution
Simplest option is to join the strings first, prior to splitting:
=SORT(UNIQUE(TEXTSPLIT(TEXTJOIN("/", , D3:D4), , "/", TRUE, 0)))
Regards
Mar 30 2023 06:50 AM - edited Mar 30 2023 06:51 AM
Mar 30 2023 06:44 AM
Solution
Simplest option is to join the strings first, prior to splitting:
=SORT(UNIQUE(TEXTSPLIT(TEXTJOIN("/", , D3:D4), , "/", TRUE, 0)))
Regards