0 leden en 1 gast bekijken dit topic.
=TEKST.COMBINEREN(",";1;SORTEREN(XML.FILTEREN("<x><y>"&SUBSTITUEREN(A2;",";"</y><y>")&"</y></x>";"//y")))
=TEKST.COMBINEREN(",";WAAR;SORTEREN(SPATIES.WISSEN(TEXTSPLIT(A2;;","))))
=DROP(REDUCE("";A2:A5;LAMBDA(a;b;VSTACK(a;TEXTJOIN(",";;SORT(TEXTSPLIT(b;;","))))));1)
=WEGLATEN(REDUCE("";A2:A5;LAMBDA(a;b;VERT.STAPELEN(a;TEKST.COMBINEREN(",";;SORTEREN(TEKST.SPLITSEN(b;;","))))));1)
=TEKST.COMBINEREN(",";WAAR;SORTEREN(SPATIES.WISSEN(TEKST.SPLITSEN(A2;;","))))