google-spreadsheet Using arrays in Google Sheets
Syntax
- ={item1,item2}
- ={item2,item2;item3,item4}
- ={{item1;item2},{item3,item4;item5,item6}}
Parameters
| Parameter | Details |
|---|---|
| itemN | It could be a value, a cell reference, a range reference or a function |
Remarks
Overview
An array of literals is written between curly brackets. Separators depends on the spreadsheet's regional configuration settings.
- To separate columns, if the decimal separator is
.use , but if the decimal separator is,then use\. - To separate rows use
;.
