To find the Last row

[anandmr]

The following is the pattern of the data I have.
I need to know which is the last row which has the data

A1 - AAA
A2- BBB
A3 - <blank>
A4 - CCC
A5 - DDD
A6 - <Blank>
A7 - <Blank>
A8 - <Blank>
A9 - EEE.

In the above example I want to get the row number as 9 as the last row
which has the data.

Can this be acheived by some formula. I tried COUNTA, but it does not
serve my purpose.

Please help.

Thanks
Anand

 

[Earl Kiosterud]

Anand,

Not sure of your question. The last row is indeed given by =COUNTA(A),
presuming the first row is row 1, and there are no empty cells along the
way. To refer to it in a formula, it's =OFFSET(A1,COUNTA(A:A)-1,0,1,1).
Same rules. To go there, you can select any cell in it, then press
Ctrl-Down.

 

[Alan]

The following is the pattern of the data I have.
I need to know which is the last row which has the data

A1 - AAA
A2- BBB
A3 - <blank>
A4 - CCC
A5 - DDD
A6 - <Blank>
A7 - <Blank>
A8 - <Blank>
A9 - EEE.

In the above example I want to get the row number as 9 as the last row
which has the data.

Can this be acheived by some formula. I tried COUNTA, but it does not
serve my purpose.

Please help.

Thanks
Anand

Hi Anand,

See my reply to your posting in the other forum:

http://www.excelforum.com/t120846-s

Thanks,

Alan.