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.

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 ...
TechRepublic

How to use the FILTER() dynamic array function in Excel

Microsoft Excel’s new FILTER() function is a great tool for reporting and dashboards. We’ll show you how to use it to get more done. Filtering is a huge part of many Microsoft Excel sheets, and ...
Windows Report on MSN

Microsoft Excel can now store multiple values in one cell

Microsoft Excel now supports multiple values, Lists, nested arrays, and new array functions inside a single cell for Insider ...
Geeky Gadgets

How to use the Excel FILTER function

Imagine you’re working on a massive Excel spreadsheet, trying to sift through rows upon rows of data to find specific information. You’ve tried VLOOKUP and XLOOKUP, but they just don’t cut it for what ...