Forum Discussion
Solved
filter stopped working
I have the following in my spreadsheet: =IFERROR(TEXTJOIN(",", TRUE, FILTER(daily!$AL$5:$AL$1001, (daily!$AJ$5:$AJ$1001=1) * (daily!$X$5:$X$1001=D86) * (daily!$AN$5:$AN$1001=D87))), "") where D86 has...
Hi Patrick, many thanks for that suggestion. There were several #N/As in the spill results, and after correcting these, it's all working again. Best regards.
You may want to place this in a cell and let it spill:
=(daily!$AN$5:$AN$1001=D87)Next, check for results that are not TRUE/FALSE.
Hi Patrick, many thanks for that suggestion. There were several #N/As in the spill results, and after correcting these, it's all working again. Best regards.
You're welcome! Glad it's been fixed.