Forum Discussion
Help with MMULT for a range containing 100,000+ values
I have been trying to solve a problem for some time now but unable to find an acceptable solution and hence requesting help from you. The attached has a snapshot of what I am trying to achieve. The ...
So you still have something to look forward to! I couldn't wait, so put my semi-annual update aside and licenced a personal version (insider beta) in order to get to grips with the tumultuous changes.
If you are prepared to accept relative referencing and copy-fill-down then the formula
= SUM(
XLOOKUP(@distinct,letter,number,,, 1)
: XLOOKUP(@distinct,letter,number,,,-1)
)will do the same job (green header).
Hello Peter, I am not really keen to implement copy-fill-down formulas. Reason being sheer size of everchanging data which might run way past the copy-filled formula range.
Since this tool will be run by junior / inexperienced resources, even if I incorporate certain checks to validate correctness / completeness of data, they can very well overlook and ignore such checks and send out an incorrect utilization report. Hence, summarily trying to avoid copy-fill-down formulas.
Since this tool will be run by junior / inexperienced resources, even if I incorporate certain checks to validate correctness / completeness of data, they can very well overlook and ignore such checks and send out an incorrect utilization report. Hence, summarily trying to avoid copy-fill-down formulas.