I’m trying to solve what should be a simple problem.
In the picture below I show what I’m trying to do, and what it doesn’t work.
I think that the range “expected result” speaks for itself.
Solving the problem for one single row (A) works perfectly.
Solving the problem for one single row with the BYROW function (B) doesn’t work, and I cannot understand why it doesn’t.
Solving the problem for several rows (C) has been a nightmare for me, and still I do not know how to get the desired result.
I think that the formula for case (C) should imply LAMBDA, VSTACK and LET functions, but I cannot get it.
Can anybody give me a hint?
I’m looking for a solution with dynamic arrays.