SKIPWHILE

Returns an array consisting of remaining items from an array after skipping all items at the beginning which satisfy the specified condition.

Syntax

=SKIPWHILE(array, test)

Arguments

Argument	Type	Description
array	Array	The array of values
test	Lambda	Test to perform on each item of the array to determine if the item is skipped

Examples

=SKIPWHILE([1, 1, 1, 3, 5, 1], x => x = 1)→[3, 5, 1]

=SKIPWHILE(["A", "B", "C", "d", "E", "f"], x => UPPER(x) = x)→["d", "E", "f"]