Forum Discussion
Trying to Sort - Can't change part of an array error
Hi, I linked some data with sumif formulas. Now I want to sort the rows by job number and the color of backfill and I am receiving an error that states "You can't change part of an array." Is the...
Janet, you can't apply SORT or modify somehow else part of the spill array/range, you need to modify entire formula. That's hard to say anything more concrete without the sample of the formula.
SergeiBaklan Can I find out where the error comes from? I got the same error "you can't change part of an array"
We'd have to see a copy of your workbook.
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?
