Display row number of the last value in a column
 

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

Display row number of the last value in a column
 

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

Display row number of the last value in a column
 

Hi,

Thanks alot Biff, Its working but with a small error, its giving me
the first false row No. Any how there is no problem I'm deducting 1
from the resukt and I'm getting my answer.

Thanks and Regards

Ramana

Display row number of the last value in a column
 

=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

Display row number of the last value in a column
 

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