•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
BYROW with dynamic range, not working as expected?
Our take
Are you struggling to make the BYROW function work as dynamically as you hoped? You're not alone. Many experienced Excel users face challenges when transitioning from traditional formulas to more advanced functions. In this case, the goal is to replace repetitive dragging with a seamless dynamic solution. The formula you’ve shared, using BYROW and LAMBDA, holds promise, but understanding its nuances is key to unlocking its full potential. Let’s explore why your BYROW approach might not yield the expected results and how to troubleshoot effectively.
Hello everybody!
this works; but it is not dynamic, I would have to drag down to get results for all rows:
=SUMPRODUCT($P$2#*XLOOKUP(A2;$Q$1#;$Q$2#))
then, I wanted to replace dragging down with a dynamic function, by using BYROW.
=BYROW(CHOOSECOLS(A2#;1);LAMBDA(x; SUMPRODUCT($P$2#*XLOOKUP(x;$Q$1#;$Q$2#))))
I am an experienced Excel user, but for some reason I cannot get my head around why the BYROW one does not give the same results.....
thanks anybody for making me understand!! :)
[link] [comments]
Read on the original site
Open the publisher's page for the full experience