Forum Discussion
Renae225
Jan 06, 2022Copper Contributor
=filter formula
Hi everyone, I am having issues with my =filter formula. It works fine on my computer, but when colleagues open the worksheet and start working on it, the filter doesn’t flow through on different s...
SergeiBaklan
Jan 06, 2022Diamond Contributor
“can’t change part of an array” means you try to change the cell inside the spill returned by FILTER(). You may change only entire formula in top left cell of the spill.