1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Nested arrays UI just showed up in Excel Beta (v2604 19901.20000)… but it’s broken?

I’m on Excel Beta Channel Version 2604 (Build 19901.20000) and this morning I noticed a new UI “button”/surface that strongly looks like it’s for nested arrays support.

Right now the button seems broken (at least for me), but the intent is clearly there. instead of the current “#CALC! nested array” limitation we’ve all worked around in REDUCE+V/HSTACK land.

If anyone else is on v2604 build 19901.20000 and can reproduce (or gets it working), can you share what it’s supposed to do / where it writes output / what formulas it affects?

https://preview.redd.it/h8qyvdcmrwmg1.png?width=745&format=png&auto=webp&s=b6a3908d4957a55ec0c337dc53613c7a92754fef

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

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel
#nested arrays
#Beta Channel
#Version 2604
#Build 19901.20000
#UI
##CALC!
#REDCUCE
#V/HSTACK
#formulas
#output
#intent
#button
#limitation