This is driving me mad and I can't find the right words for Google to get what I need.
If I have an array formula like {=A1:A9}, how do I replace the range in the formula with the actual values held in the array e.g. ={1,2,3,4,5,6,7,8,9}
Possibly it wasn't a shortcut so much as a 'technique' to do this, but I've definitely done it before.
Bookmarks