Forum Discussion
aca247
Feb 21, 2023Copper Contributor
TheOldPuterMan I've had the same issue when just trying to return an array in another sheet i.e. =C2:C330. Simple solution is just put substitute around the whole formula =substitute(formula,"0","").
This works provided you don't want any cells with a 0 value i.e. text only arrays or values <>0.
Hope this helps