Hello,
I am experiencing great difficulties with the TEXTJOIN function as an array (CSE). In my attached workbook, the "comments" column joins text based on whether or not there are values in columns 1-13.
It is working fine, however, as soon are there's a function in the cells with numbers, it behaves oddly. It works fine, until i start sorting the cells. Whenever i sort for a value, and then clear the filter, the comment cell, which is supposed to show a string of text, is just blank for the cell where it drags the number from a function.
In my workbook, the cell H6 drags its number from A16 (234). When i sort, and then clear the filter for a random value, the comment associated with the cell disappears.
Thanks for your help!
Bookmarks