Of course!

Don't know what I was thinking. I'm having a rough week!

Biff

"Aladin Akyurek" wrote in message
...
=MATCH(9.99999999999999E+307,A1:A1000)

ramana wrote:
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