Forum Discussion
Wider Excel discussion
Hi David,
Craig Hatmaker is including some thunks in his BXL 5g modules.
I am getting comfortable with using thunks to reference arrays that I want to access within a calculation. If I am not allowed an array of ranges/arrays, sobeit; I will use an array of functions. What I would like some support on is getting Microsoft to implement a built-in function that evaluates and stacks an array of thunks as EVALTHUNKARRλ does. Our function is full of tricks and works pretty well but I can't help thinking that it would perform better and be more acceptable to the user community as a built-in function.
On an entirely different track, something else I would like is
= VSTACK(
STYLE(result, "Output"),
STYLE(BYCOL(result, SUM), "Total")
)which could give nicely formatted output without resorting to the nightmare world of conditional formatting!
Agreed: a built-in EVALTHUNKARRλ function would be ideal. The STYLE concept would also be neat, if they could pull it off. Perhaps something akin to CSS, where you define and apply your own custom styles?
Sounds like Pivot Tables are getting an "Auto-Refresh" option, which is long overdue. GROUPBY and PIVOTBY are great, but difficult to format (they also lack basic options like choosing to "insert blank line after each item label" or to NOT "repeat item labels"). I tend to use them more as an intermediary step for solving larger problems, rather than the final output. It would be super helpful if Conditional Formatting rules could be applied to a dynamic spill range. 😏