ARRAYREMOVE

Creates an array by referencing an existing array and then removing specified items.

Syntax

=ARRAYREMOVE("Array","index","index",#(indexes)

Example

In this example, cell F19 contains this array, created with the ARRAY function:

#(123,789,TRUE,FALSE,"Test","a","b","c")

This function creates an array from which the third and eighth items are removed:

=ARRAYREMOVE(F19,3,8)

This is the resulting array:

#(123,789,FALSE,"Test","a","b")