top | item 32743619

(no title)

evandwight | 3 years ago

Don't they have arrays in single cells?

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

discuss

order

cm2187|3 years ago

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.

evandwight|3 years ago

Ah thanks for clearing that up

spywaregorilla|3 years ago

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.