value1 is 3 columns wide and value2 is 4 columns wide), the additional rows and/or columns will be filled with #N/A errors. An example of one possible use for this can be found here: https://techcommunity.microsoft.com/t5/excel/generating-a-2d-array-from-sumifs-on-...
value1 is 3 columns wide and value2 is 4 columns wide), the additional rows and/or columns will be filled with #N/A errors. An example of one possible use for this can be found here: https://techcommunity.microsoft.com/t5/excel/generating-a-2d-array-from-sumifs-on-the-columns-...
value1 is 3 columns wide and value2 is 4 columns wide), the additional rows and/or columns will be filled with #N/A errors. An example of one possible use for this can be found here: https://techcommunity.microsoft.com/t5/excel/generating-a-2d-array-from-sumifs-on-the-columns-...
value1 is 3 columns wide and value2 is 4 columns wide), the additional rows and/or columns will be filled with #N/A errors. An example of one possible use for this can be found here: https://techcommunity.microsoft.com/t5/excel/generating-a-2d-array-from-sumifs-on-the-columns-...
I'm not quite sure how passing a sequence as the choice variable could result in a jagged array, but I am sensing that an array function is done more "at the same time" than I was imagining.I'm still not sure why things would be evaluated (and compared) prior to ...
An example of one possible use for this can be found here: https://techcommunity.microsoft.com/t5/excel/generating-a-2d-array-from-sumifs-on-the-columns-of-another-2d/m-p/4203110#M234834 I hope that helps. Cheers!
Internal Server ErrorSomething went wrong