SKIP
Returns an array consisting of remaining items from an array after skipping the specified number of items at the beginning.
Syntax
=SKIP(array, count)
Arguments
| Argument | Type | Description |
|---|---|---|
| array | Array | The array of values |
| count | Number | The number of items at the beginning of the array to skip |
Examples
=SKIP([1, 2, 3, 4, 5], 3)→[4, 5]
=SKIP(["A", "B", "C"], 1)→["B", "C"]
=SKIP([], 4)→[]
=SKIP(["x", "y", "z"], 4)→[]
Updated over 1 year ago