4 ms·

Don't they have arrays in single cells? https://www.lifewire.com/excel-single-cell-array-formula-3123734 https://www.lifewire.com/excel-single-cell-array-formu

• cm2187 4y 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 4y ago
    Ah thanks for clearing that up
• spywaregorilla 4y 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.