Use of named arrays

MyOffice Spreadsheet supports operations with named arrays in formulas and compatibility of named arrays with functions such as INDEX, MATCH, and so forth.

You can set a name for an array based on a range in the range field or in the Name manager, just as you would for a regular range of cells.

You can set a name for an array of constants in the Name manager by directly entering the array in the Reference box.