This article describes the formula syntax of the ARRAY.SHIFT function.
Return shifted array.
ARRAY.SHIFT(array, n)
array is an array or handle to an array. n is the number of elements to shift.
If n > 0
then shift right. If n < 0
then shift left.