Is there a way to use array formulas or some other feature to essentially have an excel function that means.
Essentially, I want to refer to multiple locations where you would normally type a contiguous range. Non-VBA preferred, if that is indeed possible.
I know I can use
in this case, but it isn't ideal for obvious reasons.
Thanks everyone :)