Last Non-Empty Cell in a Column in Excel

From NovaOrdis Knowledge Base
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"