Hi!

Try this:

=INDEX(ROW(A1:A1000),MATCH(LOOKUP(9.99999999999999 E+307,A1:A1000),A1:A1000,0))

Biff

"ramana" wrote in message
ups.com...
Hi everybody,


I have a conditional formula in column A(A1:A1000) if the
condition is satisfied then the cell returns a value, if the condition
is not satisfied the cell returns "FALSE". No in B1 I wanted have a
formula that what is the last row nukber in columnA that has value.
Ex:
ColumnA B
1 23 Now B1 should Return 5 For me.
2 12
3 11
4 9
5 24
6 FALSE
7 FALSE
8
9
10
11
..
.
.
.

can anybody help me on this problem.

Thanks and Regards

Ramana