I'm having some problems with the StringConcat macro from Cpearson:
When used in the standard way, it seems to work fine. However, when using an array with multiconditions it seems to fall short or I'm not applying it properly (I'm tipping its the latter).
For example, the macro seems to work fine like this:
(array entry with ctr+sht+enter)
However, if I want the function to return values based on additional conditions, like if results from MID() match a defined name it seems to only output the first two results:
I've tried to simplify the formula to this:
But encountered the same problems.
I thought the input array might be getting too large and I was running into some memory limitations, so I reduced the data range and defined name range with the same results.
The strange thing is, when I "evaluate" the results in excel I can see the correct output, but for some reason only the first two results are displayed and the rest seem truncated?
I've posted a spreadsheet to better highlight the problem (& stop me from blabbing on)...