Forum Discussion
Solved
Product of numbers in a row in a dynamic array
How does one do row-by-row evaluations with a 2d dynamic array? For example, I need the product of all the numbers in each row in an array. I can only seem to find ways to get the product of all ...
This is something I have been complaining about for a couple of years or so now but, as JKPieterse says, the definitive solution is to be found in the Insiders beta Channel. BYROW will return each row as a distinct range reference and supports any relevant calculation.
As an interim workaround, the multiplication of positive numbers may be performed by using logarithms
= EXP( MMULT(LN(array#), {1;1;1}) )
You probably need the new BYROW function: https://support.microsoft.com/en-us/office/byrow-function-2e04c677-78c8-4e6b-8c10-a4602f2602bb