We’re rewarding the question askers & reputations are being recalculated! Read more.

Use for questions about using arrays in Google Sheets

Use for questions about using arrays in Google Sheets like

={"Name","Favorite meal";"Ana","Spaghetti";"Ben","Hamburger"} 

which is displayed as

  |   A    |       B
--+--------+----------------
1 |  Name  |  Favorite meal
2 |  Ana   |  Spaghetti
3 |  Ben   |  Hamburger

NOTES:

  • Some functions are able to use arrays as arguments but other require a reference.
  • Spreadsheet using comma as a decimal separator should use \ as column separator instead of a comma.

Related functions

Related tags

Reference

history | excerpt history