Is this really hard?
Excellent! This is what I needed.
Thank you
Diana
-----Original Message-----
Diana,
It depends on how your data is structured. Dick's
solution will work in
most situations. A simpler solution is a formula like
this:
=COUNTA(A:A)
But this will only work if all rows have data in column
A (and there are no
blanks in column A before the last row).
Regards,
Jake Marx
MS MVP - Excel
"Diana" wrote in message
...
Hello everyone,
This is the third time I post this request. I don't
seem
to get any relevant help.
I need a function that would let me know the number of
the last row that is populated with data.
For instance if my default range is A1:D2000 and my
populated Range is A1:D32, the function needs to return
32 as a result.
I appreciate your help
Diana
.
|