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

downloadDownload PNG downloadDownload JPEG downloadDownload SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter