Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to automatically number an index column | Excel Worksheet Functions | |||
Using the last number in a column | Excel Discussion (Misc queries) | |||
Get Column Letter from Column Number | Excel Worksheet Functions | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
Lookup values in a column and display them in order with no gaps | Excel Worksheet Functions |