=CDR(A1:A5)
-> A2:A5
DEFINE(
CDR,
LAMBDA(
range,
IF(
GREATERTHAN(
COLUMNS(range),
ROWS(range)),
MAKEARRAY(
1,
DECREMENT(COLUMNS(range)),
LAMBDA(
_row,
col,
INDEX(
range,
1,
INCREMENT(col)))),
MAKEARRAY(
DECREMENT(ROWS(range)),
1,
LAMBDA(
row,
_col,
INDEX(
range,
INCREMENT(row),
1))))))
Help us optimize this function