|
RESIZE Function
Produces an expanded or contracted array copy of an array, range, Table or spill reference. Expanded cells may be filled with a Fill value.
RESIZE is a multi-threaded, non-volatile array function.
RESIZE Syntax
RESIZE (InputArray [, NumRows] [, NumCols] [, FirstRow] [, FirstCol] [, Fill])
InputArray
Array, Table, Range or Spill reference to resize.
NumRows (Optional, default -1= all rows)
Optional: the number of rows in the output array. Can be smaller or larger than the input array. Default is all rows: output size is the number of rows in an array formula entered into multiple cells, or the number of input rows in a single-cell formula.
NumCols (Optional, default -1= all columns)
Optional: the number of columns in the output array. can be smaller or larger than the input array. Default is all rows: output size is the number of columns in an array formula entered into multiple cells, or the number of input columns in a single-cell formula.
FirstRow (Optional, default the first row in the InputArray)
Optional: default the first row in InputArray. The start row in InputArray for the resize
FirstCol (Optional, default the first column in the InputArray)
Optional: default the first column in InputArray. The start column in InputArray for the resize
Fill (Optional, default 0.0)
A cell or character or digit to be used to fill expanded cells in the output array, for example 0.0 or “”.
|
