MicrosoftHi people,
Just find that 14 new DA functions are coming. SUPER!
I just imaging how did I work without them
=STACK - unioning Arrays
=TAKE - much better than using INDEXES for selection part of DA
=ROWS and =COLUMNS - this same
=TOROW and TOCOL - SUPER!
and last but not least 🙂
=TEXTSPLIT, =TEXTBEFORE, =TEXTAFTER - great - I can now forget my function add ins (=HLINK is something I need from MyFunctions)
=TEXTSPLIT I find strange behaving
I have column (excerpt from table) fith names separated by commas (Henn, Ants, Peeter) - and several rows with different set of names in each
On one cell (C2) =TEXTSPLIT( works fine, but on DA (C2#) stop work - producing ONLY one column (1st names from each)
Fortunately I find VERY FANCY workaround TEXTSPLIT(TEXTJOIN(";";TRUE;C2#);",";";";TRUE;"") producing exact the result I need
so with following formula I get what I need to get:
=LET(
m;TableX[Names];
s;TEXTSPLIT(TEXTJOIN(";";TRUE;m);",";";";TRUE;"");
c;UNIQUE(TRIM(TOCOL(IF(s="";0/0;s);3)));
c)
NB! Excuse againg - I need to use semicolons rather than commas in formulas
AHA! My question - Why that TEXTSPLIT dont work on DA-s
