Forum Discussion
TextJoin returning 0 values despite content being in the originating field
I have a formula that is pulling in correct data except for a few lines in my "master grid." (See formula below)
For some random lines, it pulls in "0" instead of the text that is in the fields on the master grid. I can't figure it out for the life of me. Can anyone help?
TEXTJOIN(" • ",TRUE,IF('Master Grid'!K187:K288="x",'Master Grid'!$AL187:$AL288,""))
The formula concatenates values from column AL:
=TEXTJOIN(" • ",TRUE,FILTER('Master Grid'!$AL187:$AL288,'Master Grid'!S187:S288="x",""))
The text "Leading through conflict is in E211, not in AL211. That's why the formula doesn't return it.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
I saved a copy of the two tabs. However, the formulas in the "Seminars by Core Discipline" are still pulling from the original document. But you should be able to at least see the content it's supposed to be pulling from and see if there's something wrong with the rows in the master grid tab. Thanks!
Try
=TEXTJOIN(" • ",TRUE,FILTER('Master Grid'!$AL187:$AL288,'Master Grid'!S187:S288="x",""))
There is a limit:
If the resulting string exceeds 32767 characters (cell limit), TEXTJOIN returns the #VALUE! error
But that is not relevant here.
There is another limit. Excel displays only the first 1024 characters.
