Trending storyPast story
Excel now supports multiple values in a single cell
1 report1 sourceupdated 4 days ago
What happened
Summary
微软在 Excel 的 Insider Beta 版里塞进了列表、单元格内数组和嵌套数组。一个格子可以存多个独立的值，还能分别筛选和计算，不再是粘成一团的文本。同时加了四个新函数：FLATTEN 用来把嵌套结果拍平，HAS、HASANY、HASALL 用来按成员查找。正文没提什么时候正式上线。
Coverage
Follow the reports to see the story from different sides.
Sep 26
- Hacker News front pageExcel now supports multiple values in a single cell
Microsoft shipped lists, in-cell arrays, and nested arrays to Excel Insiders Beta. A single cell can now hold multiple values that remain individually filterable and calculable, instead of being treated as plain text. Four new functions—FLATTEN, HAS, HASANY, HASALL—help flatten nested results or search by member. The post doesn't disclose a general availability date.