←Back to Beyond Market Intelligence
•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Thoughts on Peter Bartholomew's BYROWλ solution to BYROW that can return arrays of arrays?

Our take

In a recent discussion on the MS Community Hub, user bradland expressed frustration with #CALC errors while using BYROW for solutions that naturally require array results. This led to the exploration of Peter Bartholomew's BYROWλ solution, which aims to return arrays of arrays instead of just scalar values per row. The conversation raises important questions about the limitations of BYROW and the need for more flexible functions in spreadsheet technology. Are others facing similar challenges, or have they found effective alternatives?

GitHub Gist

MS Community Hub Discussion

Fed up with #CALC errors when developing solutions seem like a natural use for BYROW, but need an array result per row, I started building some utility functions for cramming results into thunks and then unpacking them later.

Then I thought, "I should just build a generalized BYROW solution that handles array results."

Then I thought, "I bet someone has built this."

And now here I am looking at Peter Bartholomew's BYROWλ (and friends) and wondering, "Is this too far?"

Is anyone else here using something like this? Why did Microsoft decide that BYROW should return scalar values per row? That's rhetorical, of course. No one knows the answer to that question.

I'm just so tired of #CALC errors when BYROW feels like such a natural fit for a problem. I'm mostly curious if others are using functions like these, just relying on thunks, or simply avoiding BYROW/BYCOL when array result are needed?

submitted by /u/bradland
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Tagged with

#rows.com