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.
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.