ArrayFormula stops working after shuffling rows

Published: 14/06/2019
ArrayFormula stops working after shuffling rows
Source: WEBAPPS.STACKEXCHANGE.COM

I have a pretty extensive sheet wherein many columns I use an array formula to automatically fill data in from various other spreadsheets. The problem I have is when I need to rearrange rows then what is in that row output from array formula stays there as plain text after moving and that prevents the array formula from working because it cannot overwrite data in those cells that now contain text.

Read more
Related news
Comment
FACEBOOK