Lastrow without useing VBA (RESOLVED)

[Skyhook]

Is there a formula that can be placed in a cell to find the last data in another Column?
If possable, without using VBA.
Thanks in advance
This message was edited by Skyhook on 2002-05-10 09:12

 

[Skyhook]

Thanks Aladin for all the help. That solved my problem.

Jotting down things like that... No wonder??

 

[Aladin Akyurek]

Jotting down things like that... No wonder??


I was referring to my sloppiness...

By the way, you could also use:

=OFFSET(V9,SUMPRODUCT(MAX((V9:V37>0)*(ROW(V9:V37))))-ROW(V9),0,1,1)

Aladin

PS. Your question marks made me nervous about the expression I used. Webster says:

to write briefly or hurriedly

I meant of course: writing up in a hurry.

 

[Skyhook]

I thought that you might have ment that i need to go into a little more detail with my question so everyone would know what i was looking for.

Anyway, Thanks again for all the help.
Two Thumbs Up for Aladin!!