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")