Row number in a column

[Jeff]

Hi,

I have a column "A" with numbers and some blank spaces.
How do I automatically get the last nonblank number's row number?


Thanks a lot for your help.

 

[Domenic]

=LOOKUP(2,1/A1:A100,ROW(A1:A100))

Hope this helps!

 

[Frank Kabel]

Hi
see:
http://www.xldynamic.com/source/xld.LastValue.html