Last Non-Empty Cell in a Column in Excel

From NovaOrdis Knowledge Base
Revision as of 04:20, 21 December 2023 by Ovidiu (talk | contribs) (→‎Overview)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Internal

Overview

=INDEX(A:A,MAX((A:A<>"")*(ROW(A:A))))

Retrieved from "https://kb.novaordis.com/index.php?title=Last_Non-Empty_Cell_in_a_Column_in_Excel&oldid=103897"