ARRAYREMOVE
This function creates an array by removing referenced items from an existing array.
Syntax
=ARRAYREMOVE(array,index {,index})
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")