ARRAY.SHIFT function

This article describes the formula syntax of the ARRAY.SHIFT function.

Description

Return shifted array.

Syntax

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.