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