@Peter Bartholomew Thank you for the details and your innovative
solution, although frankly, I have yet to catch up with these new
functions and more particularly their interface, interactions and
nesting which you have displayed above, quite beautifully. I am just a
starter yet.Just to elaborate in...
@jignesh0yt2k This is just part of the ongoing battle with the new
functionality (Lambda helper functions especially), coercing them to
deal adequately with problems involving 'arrays of arrays' (that is
normal spreadsheet models). If, as in Hitchhikers Guide to the Galaxy,
the answer to your proble...
@Henn Sarv Thank you for your solution posting. See here the limitation
of using TEXTJOIN (Solution posted by Scott Craner:
https://stackoverflow.com/questions/76065555/how-to-use-textsplit-on-a-column-from-a-dynamic-array-spill-range-in-excel)
It clarifies that "One note, TEXTJOIN does have a limit...
@MeniPorat Thank you for posting your solution. I found the same here
before that:
https://stackoverflow.com/questions/76065555/how-to-use-textsplit-on-a-column-from-a-dynamic-array-spill-range-in-excel
(posted on April 20, 2023) (Some other workaround options can also be
found there) and from:
http...
The new browser UI don't allow me to read all the thread but ...I had
similar problem with textsplit against dynamic arrays. THere is most
simplest way to bypass this limitation1st =TextJoin this dynamic array
and then textsplit this to multiarray. Works
finemydynamic=array(Fist,LastFirst,Last...)=t...
Latest Comments