FILL

Use the FILL function to preset or initialise all items in an Array to be the same value.

Use

FILL( value, count )
Create an array with the specified number of items, each filled with the given value.

Parameter	Required	Description
value	Yes	a value of any type
count	Yes	the number of items to create in the array

Returns

Array matching the type of value

Example

This section isn’t ready just yet—we’re working on it! Please check back soon, and if you need help right away, feel free to ask in our Community Forum.