ExcelAnalyticshttps://sysmod.wordpress.com/
#Excel #dynamic #array #cumulative sum
To calculate a 2-D array where each row is the #cusum of each row in the source table, it’s possible to use the #MMULT function. The #matrix multiplication is done with an upper-right triangular array of 1s. But when you get to 1000 rows, the matrix is a million-cell array, and for 3000 rows or more, #MSExcel is going to go out of memory.
Here is an efficient method of doing this for a dynamic array cusum down columns.
#Excel #dynamic #array #cumulative sum
To calculate a 2-D array where each row is the #cusum of each row in the source table, it’s possible to use the #MMULT function. The #matrix multiplication is done with an upper-right triangular array of 1s. But when you get to 1000 rows, the matrix is a million-cell array, and for 3000 rows or more, #MSExcel is going to go out of memory.
Here is an efficient method of doing this for a dynamic array cusum down columns.
