=LAST(A1:A5)
-> A5
DEFINE(
LAST,
LAMBDA(
range,
IF(
GREATERTHAN(
COLUMNS(range),
ROWS(range)),
INDEX(
range,
1,
COUNTA(range)),
INDEX(
range,
COUNTA(range),
1))))
Help us optimize this function