Hi, back again asking for help. I need to lean a worksheet of all array formulas and I don't know how to "translate" this one.
where alfa is a cell. This formula appears everywhere and alfa is always different so I cannot simply create a row with the argument of the PRODUCT formula for I would have to create a lot of rows. Of course the array formula works beautifully but as I said I need to remove them all (if it is manageble){PRODUCT(alfa+a1:z1)}
Is there any trick which would do the job ?
thanks a lot for any suggestion
Paolo
Bookmarks