open_in_new
content_copy
=INDEX(I1:I, ARRAYFORMULA(MAX(ROW(I1:I)*(--(I1:I<>"")))))