Forum Discussion
Product of numbers in a row in a dynamic array
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}) )
No worries at all. I did understand how to interpret your XOR suggestion from yesterday. However this doesn't appear to work and this really doesn't matter:
You are quite right of course. I had placed the formula snippet within BYROW; in which case you could have used
= BYROW(nums, PRODUCT)in the first place! My apologies.
Re. Error Mngt, here is what could happen and one (me) doesn't test them all in real conditions - when saving the workbook:
After 1st investigations, all ERROR.TYPEs > 7 can't raised with an array as I used in the workbook I shared (tempo. removed)
Will look into this when time allows & provide an update
Sincere apologies!
No problem at all PeterBartholomew1. Just wanted to check with the Master that I didn't miss something. And of course 365 makes life easier 🙂