Thread: Last filled row
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default Last filled row


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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Alberto Pinto" wrote in message
...
Hi!

How can I know what is the last row filled with sometinhg on a page.
I want to get always the last row of a list but that list is variable.

Thanks in advance.