MUO on MSN

Excel’s MAP function is genius

Don't copy formulas cell by cell — you're working way harder than you need to.
Windows Report on MSN

Everything Microsoft added to Excel in September 2026

Microsoft added multiple values per cell, new array functions, Center Across Selection, and Copilot editing to Excel in ...

Microsoft Excel can now put multiple values in a single cell

Microsoft is changing one of Excel’s most familiar rules: a cell no longer has to contain just one value. The company has ...

Microsoft Excel Beta Lets Single Cells Store Nested Arrays

Microsoft Excel cell arrays let you store multiple rows and columns directly inside one cell. Test this beta feature to ...

Excel Breaks a 40-Year Rule: Microsoft Lets One Cell Hold Multiple Values

Microsoft is changing a 40-year-old Excel rule by allowing a single cell to hold multiple values using new lists, arrays in cells, and nested arrays.

After 40 years, Excel is breaking one of its oldest rules: one cell, one value

Lists are the most straightforward part of the rollout. A user can create one through Insert > List or by pressing Ctrl+J, then add items separated ...
TechRepublic

Use an Excel array function to create an AverageIf function

Excel doesn’t have a built-in AVERAGEIF() function, but you can still average values, conditionally. Excel has SumIf and CountIf, but no AverageIf. However, with a little array magic, you can get ...