CREFLEX() to apply a named range to the data body of the result
What if in a reflex report the CREFLEX formula created a named range for the resulting data and re-sized/defined it each calculation?
That would let you reference/slice the named range pretty effectively without breaking the formula or relying on offsets. Ie: =INDEX(returnedData,1,)
The function is already re-sizing the range by cell reference so it should be an easy implementation.
I think this is a great idea!
We have it in our backlog of work to be implemented in the short term (0 - 3 months)