LAST
=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