@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...
Latest Comments