Thread: Last populated cell in a column
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein Rick Rothstein is offline
external usenet poster
  
Posts: 5,934
Default Last populated cell in a column
=INDIRECT("A"&SUMPRODUCT(MAX((ROW(A1:A1000))*(A1:A 1000<""))))

A little bit shorter...

=LOOKUP(2,1/(A1:A65535<""),A1:A65535)

--
Rick (MVP - Excel)
Reply With QuoteReply With Quote