Edit mode press F9 F9 does work, but not in the sheet.
Trying to avoid macros and vba and named array (need too many)
What I want to do here does work if this is entered into a name as reference to: so that is not an answer I am looking for.
I am looking for an answer that can do maths on 2 x 99 array constants entered in single cells.
Tried with INDIRECT, I'm sure there's something I am forgetting here, to do with being able to make formulae construct themselves.
Here's the typing:
and the result of the concatenate (which does work in itself)
How to get that array constant indirectly into the formula?