Another Spilled Array connundrum. Variant of a previous discussion that was solved.
Follow on from
In this situation, I am trying to extend the concept of a previous discussion that was expertly solved by an esteemed contributor here.
Best illustrated by the attached workbook which also shows the previous version with its best solution.
Look at Revision 2 for this one. The situation in this version is that I want to multiply the various rows in the spilled array not by a single other range (spilled array) by a matched row in collection of ranges (spilled arrays) based on the driver.
So if the driver for row 1 is Headcount then I want to multiply that row by the relevant row in the Headcount array (relevant row is determined by the Entity). Another row in the main table may have the driver % Net Revenue so I will multiply that row by the Net revenue table (selecting the appropriate entity row) and then by the Growth factor.
Thanks in advance.
Follow on fromhttps://techcommunity.microsoft.com/t5/excel/another-dynamic-spilled-array-challenge-multiply-2-spilled/m-p/4263784 In this situation, I am trying to extend the concept of a previous discussion that was expertly solved by an esteemed contributor here. Best illustrated by the attached workbook which also shows the previous version with its best solution.Look at Revision 2 for this one. The situation in this version is that I want to multiply the various rows in the spilled array not by a single other range (spilled array) by a matched row in collection of ranges (spilled arrays) based on the driver. So if the driver for row 1 is Headcount then I want to multiply that row by the relevant row in the Headcount array (relevant row is determined by the Entity). Another row in the main table may have the driver % Net Revenue so I will multiply that row by the Net revenue table (selecting the appropriate entity row) and then by the Growth factor. Thanks in advance. Read More
