Hacker News new | ask | show | jobs
by evandwight 1380 days ago
Don't they have arrays in single cells?

https://www.lifewire.com/excel-single-cell-array-formula-312...

2 comments

No, these functions use an aggregation function (like SUM). If you don't use an aggregation function the value of the cell is the top left element of the array. The parent suggests a cell which value is an array object, which can then be queried by another formula.
Ah thanks for clearing that up
It's been a while, but I think these functions must be map-reduce expressions. You cannot return an array and pull out it's elements elsewhere. You cannot do operations with the resulting array. Like a merge or whatever.