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"]
Updated 9 months ago