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.
|