Display row number of the last value in a column

R

ramana

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
 
B

Biff

Hi!

Try this:

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

Biff
 
R

ramana

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy values generated by conditional formula in one sheet to the other work sheet as values 1
return values in the table with multiple conditions 3
How to get the values using a condition refering to the other column 2
Return Corresponding Value Based on Comparing Two Sheets of Data 6
With F1 value, look at A, if match or partial match return B 5
Finding values in different rows/columns 1
Count column b if column a equal cell value 7
Formula to choose from the last column of a given row 1

Top