Story · 1 source · 2 articlesfirst updated ()
Excel now supports multiple values in a single cell
Merged summary · from the lead article
Excel Insiders Beta adds lists and nested arrays that store multiple values in one cell.
Excel Insiders Beta now supports lists, in-cell arrays, and nested arrays so related values can stay in one cell. Lists can be created with Insert > List or Ctrl+J and filtered by individual items. New functions include FLATTEN, HAS, HASANY, and HASALL, and brace-wrapped formulas can keep spill results inside a single cell.
Coverage timelineoldest first · each row is one article
- · 1d agoExcel now supports multiple values in a single cell
Hacker News · security· 4
Excel Insiders Beta adds lists and nested arrays that store multiple values in one cell.
- · 1d agoExcel now supports multiple values in a single cell
Microsoft Excel beta adds in-cell lists, nested arrays, and new array functions.