Slice

This feature is free. Check out the awesome benefits of becoming a Pro User.

=Slice(Array, Expr) : array


Purpose

Slices an array according to the preferences supplied in the function.


Array

The two-dimensional field you wish to slice. The array can be expressed with:

  1. A Range: =Slice(A1:B10

  2. Raw inputs: =Slice({11,12,13;21,22,23;31;32;33


Expr

The array can be sliced in four ways:

=Slice(Array,[1];[2];[3];[4])

[1] Slices the array n steps (rows) from the top:

[2] Slices the array n steps (columns) from the left:

[3] Slices the array n steps (rows) from the buttom. The input must be a negative value:

[2] Slices the array n steps (columns) from the right. The input must be a negative value:


See

Related Functions


Get help with this function in the community →