📝Excel Beta Adds Lists and Arrays in Cells
Excel Beta Channels Now Support Lists and Arrays
TL;DR
Excel Beta Channels now support lists and arrays in cells, enabling complex data structures and new functions like FLATTEN, HASANY, and HASALL. This update is rolling out to Windows and Mac users in Version 2610 and 16.114, respectively.
Excel Beta Channels now support lists and arrays in cells, allowing multiple values in a single cell. This update introduces new functions like FLATTEN, HASANY, and HASALL, enabling complex data manipulations. If you're working with large datasets or complex calculations, this update could streamline your workflow. The feature is rolling out to Windows users in Version 2610 (Build 20520.20000) and Mac users in Version 16.114 (Build 26092111).
Key Points
Excel Beta Channels now support lists and arrays in cells, enabling multiple values in a single cell.
Four new functions: FLATTEN, HASANY, HASALL, and HAS.
Lists can be inserted via 'Insert > List' or Ctrl+J.
Arrays can be any size or shape, and nested arrays are now supported.
Compatibility Version 3 is required for most calculations involving nested arrays.
Why It Matters
If you're working with large datasets or complex calculations in Excel, the new lists and arrays feature can streamline your workflow. The FLATTEN function simplifies nested arrays, while HASANY and HASALL check for values within arrays. However, Compatibility Version 3 is required for most calculations involving nested arrays, so ensure your Excel version is up-to-date.
Comments
Be the first to comment
Enjoyed this article?
Get it daily. 7am. Free. Reads in 5 minutes.
Join 3,508 builders reading daily.