Oct 08 2020 01:18 PM
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 there a work around?
Thanks.
Janet
Oct 08 2020 10:37 PM
Click a cell in the matrix. Press the F5 key. Select "Contents" - "Current Array".
Now you can either select "Cut" in the marked area with the right mouse button.
Or "Copy" - "Paste Special" - "Values".
Then you only have the constants in that area.
Formulas should of course be insured beforehand and then copied back again.
I hope I understood the question correctly.
* It is always helpful if you always indicate the operating system and Excel version of your topic, so that you come to a faster and more precise solution proposal.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
Oct 09 2020 06:45 AM
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.
Oct 20 2022 06:06 PM
@Sergei Baklan Can I find out where the error comes from? I got the same error "you can't change part of an array"
Oct 21 2022 01:57 AM
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?