Sometimes you just need to say more than one thing! With expanded support for range results, now you can, even in 3D. Giddy up!
While ClearFactr has long had the technical ability for a function to produce multiple cells of values -- a range -- as a computed result, support for this was admittedly limited. Mostly this capability was for its own proprietary functions like CFSQL() and CFLINK(), but TRANSPOSE() also makes use of this ability.
But you needed broader support, and we listened.
We're now happy to announce generalized support for this capability, which means you can do things like this:
A1 = B1:B5
or
A1 = IF(B1 > 0, C1:C5, D1:D5)
With this capability in our pocket, we can simultaneously announce support for additional functions that utilize it:
Furthermore, functions like these that produce ranges as their outputs can serve as inputs to any other function that consumes a range, such as SUMPRODUCT().
Last but not least, tangentially related, not too long ago we released support for 3D ranges, as used like this:
Sheet1!A1=MAX(SheetA3:Sheet5!A1:C10)
Admittedly sometimes these will make your head hurt, so be kind to your users and perhaps use them sparingly 😉. It's also entirely possible that you have a crazy legacy spreadsheet on your hands that only works thanks to these things, but with ClearFactr's scenario tools, you might not need such craziness.
On the the other hand, we're always looking to learn more about how people are solving certain modeling situations. Maybe you want to chime in with some possible product development thoughts to keep pushing out the financial modeling frontier.