•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?
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]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#financial modeling with spreadsheets
#BYROW
#dynamic function
#dynamic range
#SUMPRODUCT
#XLOOKUP
#CHOOSECOLS
#LAMBDA
#drag down
#not working
#experienced Excel user
#function
#Excel
#dragging down
#same results